Bad arguments to select list item , the operation select list item cannot acccept the arguments:{"<!doctype"}

[ElSilvion]

I need help with this issue, since I can't understand why the error is in the topic, if the list is in Json format and for this I use the json decoder. If someone helps me I would be eternally grateful.

[ABG]

Your blocks are too fuzzy to read.

Please post the JSON text you want to decode and an exported .aia file.

[ElSilvion]

I extract the text from a macro that I create in the google spreadsheet, and the text is exported as follows:
[{"accion":"consultar","num":"PAST01","columna2":"Pastel","columna3":"Postre","columna4":"Juiceria","columna5":"paq1","columna6":1}]

I get it from this url Sign in - Google Accounts

[ElSilvion]

Control_de_inventarionut_1.aia (12.9 KB)

[ABG]

The JSON text you supplied is okay.

So the responseContent that arrives is not that JSON text but is something else.

Capture it and display it to see what it is.
(Either using Do It or sending it to a Label.)

FAQ Section: Debugging

Introductory Testing techniques, including DoIt - MIT Advanced Do It' to view procedure results, event arguments and local variables How to run Logcat How to use Do It in a loop Screen1.ErrorOccured message numbers SteveJG monster list of things you should not do How to show raw responseContent from your app when debugging - TimAI2 Video of copying Do It responseContent results into a board post - ABG Try/Catch Extension - Kodular AI2Debug Extension: Helps tracing runtime errors - @Ku…

[TIMAI2]

The return of <!doctype> indicates that you are getting back an html page, probably an error page.

[Spicy_Topics]

(Post deleted)

[ElSilvion]

Thank you very much for helping me, I will take into account what you found.

[ElSilvion]

ok, very likely that is, since I only checked the second anyone

[TIMAI2]

Will depend on which script editor you use, with the legacy editor it is anyone,even anonymous with the new editor it is Anyone which is the third choice, not Anyone with a google account

[Spicy_Topics]

(post deleted by author)

[ABG]

This frequent problem exposes the need for a simple is_JSON test block.

Here is my sloppy attempt, all draggable ...

[TIMAI2]

It may come back as a stringified JSON not a JSON object.....

[Spicy_Topics]

Your script url now return this..

[ElSilvion]

Yes, I already solved the problem, in the app the data I need is coming out. Thank you very much for your help, much appreciated.