Custom connector error "JSON parsing error, excepted 'string' but got 'object'."

(0) Share

Report

Posted on by EA_ITEngineer

My first Power Apps show an error when getting data from my custom connector:

JSON parsing error

My code in Power Apps button click:

Code in Power Apps button Click

My custom connector was built with Web API, and these code from my action:

Code in Web API Action

All code above is simple, and I find a similar question with a reply by 'Solution Supplier', he suggests questioner to use the flow instead of directly executing:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Custom-connector-error-quot-JSON-parsing-error-expected-object/m-p/1340566

Should I also use this method to solve my error?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

victorcp 2,350 Moderator on at

Like (1)

Report
Hi,

Looks like it is not necessary to use the ParseJson function because the custom connector already parse it to you, so try this:

Set( WeatherObj, LocalWebAPI.CallLocalAPI() );

Please let me know if it worked, if not please share the error

Was this reply helpful? Yes No
EA_ITEngineer 9 on at

Like (0)

Report
Hi @victorcp ,
I have adopted your code, but Power apps still shows the same error.
On the other Hand, I can't call the fields (such as, Date) of the WeatherObj without using the ParseJson function.
I guess the ParseJson function which looks like the var keywork in C# converts a json string to be an untyped object, so I can call some fields of the 'WeatherObj', just like the picture as followed:

  new error without using ParseJson function

Additionally, my custom connector settings as followed:
  Custom Connector Setting

Thanks

Was this reply helpful? Yes No
EA_ITEngineer 9 on at

Like (0)

Report

Hi @victorcp,
I have found lack of type setting in my custom connector , so your suggestion do work after I complete setting.

Thanks.

Was this reply helpful? Yes No
EA_ITEngineer 9 on at

Like (0)

Report

Attach new settings:

completed setting of custom connector

Was this reply helpful? Yes No