I have configured API in the Input connector, but the response of API is not correctly mapped when there is an array or nested JSON.It is only considering the parent JSON and thus all the content is not fetched properly.
Can someone please guide me if I am missing something, or this is how it behaves and there is some other approach to handle it.
API : api.waqi.info/feed/lucknow/?token=fa73462a52dbbb8848d20a0554fb72424af90975
Incorrect JSON:
Try putting "data" in the JSON object name parameter of the input connector.
Thanks for your reply @Gene_Sipes
I have already configured JSON Object Name with "data" for my case and therefore it is returning the properties correctly which are inside the "data" JSON. But for the nested json the response is not correctly mapped. Eg:- In the below api response sample, properties such as iaqi, attributions are not correctly mapped.
api.waqi.info/feed/lucknow/?token=fa73462a52dbbb8848d20a0554fb72424af90975
Can you please help me on this?
This might be worth a read, hopefully it helps:
https://community.esri.com/t5/arcgis-geoevent-server-blog/json-data-structures-working-with-hierarch...
Also, I have a JSON feed with multi-cardinality structure, albeit a simple one, but in the input definition the property with multi-cardinality looks like that below. Maybe you can adjust your definition similarly. It's the rental uris.
Hi @Gene_Sipes ,
I have validated the multi-cardinality structure, but not sure why nested json properties are still not correctly mapped.
Consider the "attributions" (for example ) in the api response, it does not even map url ,name and logo.I tried multiple ways to map it out but no luck
api.waqi.info/feed/lucknow/?token=fa73462a52dbbb8848d20a0554fb72424af90975