topic Error Code 701 and 400 when working in templates in ArcGIS Survey123 Questions

Error Code 701 and 400 when working in templates

KellySmith2 — Mon, 19 May 2025 16:35:58 GMT

Hello - I'm trying to build a form and when going in to grab the Quick Reference to help build my template, I'm getting the error message "701: An error occurred when generating field mapping json. An error occurred when querying data from the feature layer. 400: Cannot perform query. Invalid query parameters. 'where' parameter is invalid"

I created a new form and started copying over the data thinking it may be a glitch or small error in my template, and at first it was working but then as I got further into copying it, it gave those errors again. The weird thing is that if I delete lines in the spreadsheet all the way back to where it was working and republish, it doesn't start working again.

Anyone have any ideas of what could be causing these errors?

Re: Error Code 701 and 400 when working in templates

CodyPatterson — Wed, 29 Jan 2025 20:42:49 GMT

Hey @KellySmith2

Would it be possible to link the problematic xls file?

Cody

Re: Error Code 701 and 400 when working in templates

DougBrowning — Wed, 29 Jan 2025 23:54:40 GMT

Usually using bad field names. You should see little green boxes in any fields it does not like. Posting the form would help.

Re: Error Code 701 and 400 when working in templates

KellySmith2 — Mon, 19 May 2025 16:33:01 GMT

Here's my form that has the issue... hopefully that helps!

Re: Error Code 701 and 400 when working in templates

DougBrowning — Mon, 19 May 2025 18:32:28 GMT

Looks like you have been copying in from another excel sheet and breaking the validation formulas. I see it asks me to update right away from another sheet and that is bad.
Mostly it ruins all the built in checking. When adding to a new sheet you can see the errors marks right away.

Arc cannot have a field names with a period in them. See the green marks telling you the issues.

You Always, Always want to use Right-Click Paste Values when putting anything into a 123 Excel file. It can be hard to remember when crtl-c, ctrl-v is hardcoded in your brain.

I also see your media images have spaces in the names. That used to not work but not sure now.

I would rebuild your sheet at this point. I had a write up on this somewhere.

Basically make a all new form and copy that excel to your current survey dir. Rename the old one to OLDName.xlxs. Rename the new copied in blank sheet to the original excel name. Copy each row over make sure to use Paste Values each and every time! Note if the columns match perfectly you can do all but the top row at one time.

Then rename those fields with the period.

Hope that does it