cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Venwin
Regular Visitor

Creating a table from a Custom Connector's complex JSON

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. 

 

Venwin_0-1657823130279.png

 

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.

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,027)