More images.
John I think you need to first set the JSON entry point to "/" on the FIELD MAPPING tab.
Then choose edit on the same tab and set the transaction JSON path to "items" and the fields as shown. Note the relative path is false on the Header part.
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
I am writing a Web API integration that takes the client's JSON payload and returns related values.
The input data contains an object containing two objects: Header and items[]. I have tried every variation of jpath that I can think of to produce the desired dataset but the closest I have come to what I want gives me only the first item in the array.
I'll attach screenshots of the JSON input format, how I have configured the JSON Reader, and the dataset the JSON Reader produces.
How do I get the JSON Reader to output rows for all the elements in the items array?