I have a connector that pulls from an API source, which returns a list of JSON objects. The connector successfully gets the data, and detects the list key (cms_documents.CMS_News), but then in the Specify Selector step, it doesn’t detect any selectors. I tried adding selectors manually (DocumentNamePath, etc), but the data still wasn’t parsed. Is there anything I need to change in order for the data to be read?
Link to connector: https://sandbox.yext.com/s/3257730/addData/connectors/14090
Sample data:
{
"cms_documents": [
{
"CMS_News": [
{
"DocumentID": 651,
"IsSecuredNode": null,
"NodeAlias": "frandsen-financial-corporation-to-acquire-bank-of",
"DocumentNamePath": "/About Us/News/Frandsen Financial Corporation To Acquire Bank of Zumbrota and Pine Island Bank",
"NodeInheritPageTemplate": null,
"NodeBodyElementAttributes": null,
"SKUHeight": null
},
{
"DocumentID": 652,
"IsSecuredNode": null,
"NodeAlias": "frandsen-financial-corporation-to-acquire-bank-of",
"DocumentNamePath": "/About Us/News/Frandsen Financial Corporation To Acquire Bank of Zumbrota and Pine Island Bank",
"NodeInheritPageTemplate": null,
"NodeBodyElementAttributes": null,
"SKUHeight": null
},
]
}
]
}