My first Power Apps show an error when getting data from my custom connector: JSON parsing error My code i

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,Local

Power Apps - Building Power Apps

Answered

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

Like (0) Share

Report

Posted on 24 Apr 2023 09:07:59 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:

General Questions

All responses (4)

Answers (1)

EA_ITEngineer 9 on 25 Apr 2023 at 02:44:36

Like (0)

Report

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

Attach new settings:

completed setting of custom connector
EA_ITEngineer 9 on 25 Apr 2023 at 02:30:47

Like (0)

Report

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

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

Thanks.
EA_ITEngineer 9 on 25 Apr 2023 at 01:16:02

Like (0)

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

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
Verified answer

victorcp 2,347 Super User 2025 Season 1 on 24 Apr 2023 at 09:43:33

Like (1)

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

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