topic Re: Code 500 JSONArray[0] not found. in ArcGIS Survey123 Questions

Code 500 JSONArray[0] not found.

TL2 — Wed, 08 Feb 2017 15:55:22 GMT

I have attached the table below.

I am able to create the table and download it to my device. I get the Code 500 JSONArray[0] error when I try to submit.

I am trying to include multiple photos in a repeat, not sure if that is my problem?

Any suggestions?

Re: Code 500 JSONArray[0] not found.

JamesTedrick — Wed, 08 Feb 2017 17:55:14 GMT

Hi Tucker,

I'm not seeing the JSON array error, but I am seeing a failure to submit data caused by the hidden 'Auditdate_' field. By default, hidden questions are of type 'text', issues arise in converting that to date on submission. You can add a column named 'bind::type' and set the type of data for that column to 'date' - this leads to successful submission for me.

Re: Code 500 JSONArray[0] not found.

TL2 — Wed, 08 Feb 2017 18:43:40 GMT

Thanks James,

You rock!

Also, should I be able to do a relevant (='true') on a repeat?

Re: Code 500 JSONArray[0] not found.

JamesTedrick — Wed, 08 Feb 2017 19:13:56 GMT

Yes, relevancy works on displaying repeats.

Re: Code 500 JSONArray[0] not found.

TL2 — Wed, 08 Feb 2017 20:20:25 GMT

Is ${ID_1}='true' the correct syntax. When I do this it hides the repeat, but when I enter something in ID nothing happens.

Re: Code 500 JSONArray[0] not found.

TL2 — Wed, 08 Feb 2017 20:26:21 GMT

I am trying to make it so any entry displays the repeat. I see now that when you type 'true' that makes it display.

Re: Code 500 JSONArray[0] not found.

JamesTedrick — Wed, 08 Feb 2017 21:05:34 GMT

Hi Tucker,

I would use the string-length function to evaluate whether a text field is blank or not:

string-length(${ID_1}) > 0