topic Re: Survey123 Inbox Query Error in ArcGIS Survey123 Questions

Survey123 Inbox Query Error

JoshHabel — Thu, 29 Mar 2018 12:45:08 GMT

Hello,

I am getting the following error when I try to refresh my inbox. "Code 400 Cannot perform query. Invalid query parameters." I have double checked my query statement and it is okay. The field names match perfectly and when I ran the query under the REST service it worked as well. This does not make sense because it was working fine previously and then it stopped. The only thing that has really changed from when it was working is that i copied the survey to a new survey using the create new survey option. Even still the query works when tested from the new Rest. I have attached the xlsx file. The form is setup so that when the inspector sets the Quick_Pick field to Set Return the survey will show up in his inbox. My query is Quick_Pick = 'Set_Return'. Any suggestions would be appreciated!

Josh

Re: Survey123 Inbox Query Error

JamesTedrick — Thu, 29 Mar 2018 20:12:36 GMT

Hi Josh,

I'm seeing the same issue on a copy created by the Excel file you provided. It's disallowing all where queries, not just the one you provided; you can see this if you add the layer to an ArcGIS Online Map. In doing some testing, it seems that the list of fields being requested affects whether the query succeeds or not- I'm raising this with the ArcGIS Online team to see if there is a specific issue occurring here.

Re: Survey123 Inbox Query Error

JamesTedrick — Thu, 29 Mar 2018 22:29:29 GMT

Hi Josh,

You have one question in the XLSForm whose name has a hyphen in it (line 56) - this is causing the resulting table to not function correctly. Substitute that with a underscore and republish.

Re: Survey123 Inbox Query Error

JoshHabel — Mon, 02 Apr 2018 17:24:50 GMT

James,

Removed the dash and that seems to have fixed it.

Thanks!

Re: Survey123 Inbox Query Error

StephanieHickel — Tue, 08 Jan 2019 22:02:38 GMT

Hey James,

I am having a similar issue. I have created two surveys with the same geodatabase. I enabled the inbox on the more in-depth survey and am getting the same error message as Josh: "Code 400 Cannot perform query. Invalid query parameters." I doubled checked my expression, survey_type="Initial Survey". All initial surveys will have an auto populated hidden attribute "Initial Survey." Is it possible some of my irregular characters in the hints column are throwing the query off? I don't have any dashes, but I do use parentheses. I attached the survey excel doc in the group (coastal_wetlands_investment_projects) for review.

Stephanie

Re: Survey123 Inbox Query Error

StephanieHickel — Tue, 08 Jan 2019 22:04:25 GMT

Here is my Excel doc that is creating the query error.

Stephanie

Re: Survey123 Inbox Query Error

JamesTedrick — Thu, 10 Jan 2019 22:52:05 GMT

Hi Stephanie,

This query is applied in the Inbox settings in Survey123, correct? It looks like you should have survey_type='Initial Survey' (or possibly the code value if that is a field with a domain)- the difference between single quotes and double quotes matters in the query.

Re: Survey123 Inbox Query Error

StephanieHickel — Fri, 11 Jan 2019 15:01:06 GMT

Hey James,

Yes the query is applied in my inbox settings in Survey 1,2,3. I changed my query to survey_type='Initial Survey' and am still getting the same error message, "Code 400 Cannot perform query. Invalid query parameters."

Re: Survey123 Inbox Query Error

JamesTedrick — Mon, 14 Jan 2019 18:37:29 GMT

Hi Stephanie,

One way to work through the query setup is to go to the Service URL page of the layer and try out the query there, or get the query to successfully run in the map viewer (using developer tools to see the finished query).

Re: Survey123 Inbox Query Error

StephanieHickel — Wed, 16 Jan 2019 20:13:08 GMT

Hey James,

I get the same error message when I delete the query expression. No results show up in my inbox and the same error code 400 message appears. Any idea what is causing this?

Stephanie

Re: Survey123 Inbox Query Error

JamesTedrick — Wed, 23 Jan 2019 20:52:34 GMT

Hi Stephanie,

Deleting the query expression should reset the query to 1=1 (get all). Just to confirm, you did redownload the survey after altering the Inbox query and publishing (so that the new settings are applied)? If so, it sounds like something may be wrong with the query function of the feature service.

Re: Survey123 Inbox Query Error

MohammadTawbi — Wed, 22 Feb 2023 02:42:11 GMT

Hi @JamesTedrick ,

I'm facing same issue after refreshing the inbox Error 400 popped up "cannot perform query" knowing that I didn't apply any query expression to the inbox, and this error appear only after I added repeats on row 76. Please Advise