cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jernejp
Level: Powered On

Not getting correct JSON response

Hi,

 

I'm building an app that has a custom connector. This is the response I was supposed to get:

response.PNG

 

But when I trigger my request like this:

Set(
    AddActivity;
    'MyCustomConnector'.AddActivitiesToBusinessPartner( { params })
)

The AddActivity variable looks like this:

addactivity.PNG

 

I also tested the connector and got the correct responses.

testrequest.PNG

 

So my question is - does anyone understand, why I can get the correct response when I test the connector in the backend, but not when I trigger the request from within my application?

1 ACCEPTED SOLUTION

Accepted Solutions
jernejp
Level: Powered On

Re: Not getting correct JSON response

What solved the issue was when I deleted the connection to my custom connector and made a new one. Looks like it was still using the "old" version, ever though I've updated the connector.

View solution in original post

6 REPLIES 6
Community Support Team
Community Support Team

Re: Not getting correct JSON response

Hi @jernejp ,

Based on issue that you mentioned, I think you have some misunderstanding with the data storage representation within PowerApps app.

 

According to the correct response you mentioned (last screenshot), I think the dll property owns a Object value. When you executes your action within a canvas app, the Object value the dll property returned would be recognized as a Record type. Then within the variable, the dll property would be rendered as below ("table" icon):5.JPG

you could click the "Table" icon as above to see the detail values within the dll property.

Actually, it is a normal behavior that the Object record would be redered as a "Table" icon as above when your variable or Collection contains a Object value.

 

If you want to reference the column values within the dll property, please take a try with the following formula:

AddActivity.dll.retval
AddActivity.dll.BUSSINESPARTNER
AddActivity.dll.EMPLOYEE
AddActivity.dll.SUBJECT
AddActivity.dll.LOCATION
AddActivity.dll.STARTDATE

...

Note: The AddActivity represents the variable you set in your app.

 

Currently, within PowerApps, only simple type column value could be displayed within a variable or Collection directly (e.g. the status property in your response), the complex type (Object, Array, ...) column would be rendered as "Table" icon as above.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Not getting correct JSON response

Duplicated

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
seadude
Level 10

Re: Not getting correct JSON response

Hi @jernejp , also try searching the forums here for "nested JSON". There is a plethora of examples that solve exactly what you're looking for.

Good luck!

jernejp
Level: Powered On

Re: Not getting correct JSON response

What solved the issue was when I deleted the connection to my custom connector and made a new one. Looks like it was still using the "old" version, ever though I've updated the connector.

View solution in original post

jernejp
Level: Powered On

Re: Not getting correct JSON response

Thanks to everyone for your replies, really appreciate it!

Community Support Team
Community Support Team

Re: Not getting correct JSON response

Hi @jernejp ,

Have you solved your problem?

 

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 337 members 5,118 guests
Please welcome our newest community members: