Hi,
I'm trying to create a table based on some JSON returned from a custom connector I made. The connector works and gets the data I want, however I am unsure of how to actually access the data properly and make the table. Here is some of the JSON:
{
"errors": null,
"result": {
"totalCount": integer,
"searchResults": [
{
"id": integer,
"phoneNumber": "string",
"deviceModel": "string"
}
]
}
}
I know how to connect the connector to the data table itself, but a problem presents itself immediately as the only fields are error or result. I'm unsure of how to edit a formula to get what I want. I need to be able to grab the interested variables in the first result of the searchResults array and put that in the first row, 2nd entry in the searchResults array and put that in the 2nd row etc.
I selected the field as result and then tried to do something like this:
First(ThisItem.result.searchResults).deviceModel <- but this has some flaws as shouldn't ThisItem really belong to SearchResults? I'm unfamiliar with the syntax to fix this.
Do I need to put in the right formula for this to work, or do I need to change something in the connector? I am unable to simplify the JSON sent as its a 3rd party API I am connecting to.