Unanswered

Problem with PowerApps/PowerAutomate not returning nested JSON data, but custom connector test does with same parameters

(0) Share

Report

Posted on by GTW

Can't figure this one out. I have created a custom connector to retrieve transaction data from Plaid, and testing the connector works and returns the data including a nested JSON component called "added" (for transactions added since the last pull). All looks OK.

I then use that custom connector with the exact same parameters in both PowerApps and PowerAutomate (I've tried it both ways to get data) and the nested JSON is returned blank. The same call with Postman also returns data so it's something with how PowerApps or PowerAutomate process or pass back the nested JSON.

Here's the sample in the Custom Connector:

and the same in Power Automate missing the nested JSON:

Any idea what I could be doing wrong, or how I should handle this? The goal is to take the contents of the "added" object and store them into a dataverse table or a collection, however in both cases I'm just getting blank data returned. Immediately after I can run the test in Custom Connector or via Postman and get the results expected so it's definitely not a source issue.

Any ideas, insight or troubleshooting would be appreciated.

Garrett

Categories:

Connector development

I have the same question (0)

All responses (4)

Answers (0)

GTW 28 on at

Like (0)

Report

Hello,

No, definitely not a timing issue. I did the following:

1. Test via Postman, there is content in the "Added" array (it's a nested JSON container which has all the transaction details).
2. Test via Custom Connector "Test" function, there is content
3. Run the connector from PowerApps, content is missing
4. Test again via Custom Connector "Test" function, there is content
5. Test in Power Automate, content is missing
6. Test again via Custom Connector "Test" function, there is content
7. Test again in Postman, there is content.

So it consistently returns content to Postman and the Test function built in to the Custom Connector creator in PowerApps, and consistently does not return data for that array when called from PowerApps or PowerAutomate.

The trace in PowerApps monitor confirms it's the same body being sent each of the various ways, it's just the response that is missing.

Added are any transactions since the last time they were marked "transferred" -- so each time should return the same records (in this case 8 of them) until I mark them, at which time it'll then return any records since the last time they were marked in an incremental fashion.

Any ideas?

Thanks,

Garrett

Was this reply helpful? Yes No
GTW 28 on at

Like (0)

Report

Not sure where you're referring to specifically, but I assume you mean Power Automate -- no, the data is returned but not the contents of the nested array.

Was this reply helpful? Yes No
GTW 28 on at

Like (0)

Report

Same result -- body is there, but the "added" array is empty. Composing on "added" specifically just returns empty

Was this reply helpful? Yes No
YA-18101859-0 12 on at

Like (0)

Report

Garrett,

Did you ever find the answer to this, I am having the same issue only I did not use my custom connector in power automate I created a flow based on the API that the custom connector uses. That returned the results. Postman returns the results, test function returns the correct results but power apps only give me all the column names and the nested columns and values, but not the values of the higher level. When I call the custom connector I saved it to a collection that should allow for all records in my case 5 with nested last column and values. But I get a blank row with a continuation character in the last field where I click and it gives me the nested columns and values of the last item returned.

If you can give me any insight I would so appreciate it.

Thank you,

Yazmine

Was this reply helpful? Yes No