topic Send Error Code 400 in ArcGIS Survey123 Questions

Send Error Code 400

LorettaWinton1 — Mon, 24 Oct 2016 17:24:08 GMT

Hello,

I have authored a number of surveys. Both I and field workers are able to use and submit data. But one surveyor can not submit data from one of the surveys (Gemmamyces_monitoring_survey_v2), the other surveys work fine. He gets error code 400 Invalid URL whether he is trying to submit from the Outbox or immediately. The type of his connection to the internet does not matter (cell or good WiFi). Strangely, on the Download Surveys page, he has a down arrow instead of the circular arrow (which makes it appear that he has not downloaded the survey, although he has). The date and time listed under "Updated 4/28/16 8:14 AM" is the same as everybody else's. We tried Fix Database under Settings, but it did not resolve the issue. I really need to get that data to upload. Is there anyway to recover it?

Thanks,

Loretta

Re: Send Error Code 400

JamesTedrick — Mon, 24 Oct 2016 18:22:48 GMT

Hi Loretta,

It sounds like the particular version the surveyor used was deleted and a new survey republished. Assuming that the surveys are identical (the screenshot above indicates an iPhone):

1) Connect the device to a computer with iTunes.

2) If prompted, have the phone trust the computer so that iTunes can connect

3) Once the phone connects, a small phone icon will appear next to the dropdown to select Music/Videos/Apps. Click on the phone icon to enter the phone configuration information.

4) At the sidebar to the left, click on 'Apps'

5) You should see a display of the home screens of the phone in the main window. Scroll to the bottom to get to the File sharing section (it's very often hidden). Select the Survey123 application and then select the ArcGIS folder and click 'Save As' and choose a destination folder. This shows the procedure:

(view in My Videos)

6) The ArcGIS folder you saved has the following subfolders:

- AppStudio

- My Survey Attachments - this will be where any images have been saved and are referenced later in the data

- My Surveys - this will have a folder per survey (the survey's item id), along with Maps (any offline base maps) and Data. Data is the folder containing all survey responses. These are stored in the .sqlite file.

7) From here in terms of recovery, there are a few paths to recovering the data.

- The easiest path is download the Survey123 application on your computer and copy the 'My Surveys' folder to overwrite the one created by the desktop application (either in /users/<username>/ArcGIS on a Mac/Linux or c:\users\<username>\ArcGIS on Windows) and then attempt to submit or re-download the form and submit. Given you're description above, I don't expect it to work- it looks like the survey forms have different IDs.

- This database can be opened in ArcGIS Desktop, but the data is encoded differently than how ArcGIS Desktop would expect it. I've worked on a script that exports these as a cvs file (attached); there are a few issues with non-ASCII characters (Python 3 would be preferred to avoid that). Then the data can be combined with the other survey information, either through tools like ArcGIS Desktop or by downloading the CSV of the other surveys

Re: Send Error Code 400

LorettaWinton1 — Tue, 08 Nov 2016 23:08:18 GMT

Hi James,

I tried all of that and got the .sqlite file. Now I am stuck at the Python part. I don't know anything about running Python scripts but found somebody who does. We noticed that the IN_DB and OUT_DIR pointed to your machine and so changed that to my machine. After running the script we got the following errors.

Runtime error
Traceback (most recent call last):
File "<string>", line 52, in <module>
File "<string>", line 19, in readS123db
TypeError: list indices must be integers, not str
>>>

Would it be at all possible for me to send you the sqlite file and you send me the csv file? I really don't know what I am doing.

Thanks a bunch,

Lori

Re: Send Error Code 400

LorettaWinton1 — Wed, 16 Nov 2016 00:15:26 GMT

Hello? Anybody? I sure would like to retrieve that data!!

Re: Send Error Code 400

JamesTedrick — Wed, 16 Nov 2016 00:41:58 GMT

Hi Loretta,

It's a little hard to debug with just the error you provided; given the line number, it's the statement:

outRow = jRow["attributes"]

If that's the case, it sounds like the the previous line has not created an object from the data part of the row stored as a string. Line 19 should be

jRow = json.loads(json.loads(row[1]))

you might try wrapping another json.loads() around. One way to find if you're on the right track is to do a

print jRow statement and observe what it looks like

Below are examples of what the print statement returns as the program converts the data into into an object; it needs to look like the last one :

row[1]:

"{\"attributes\":{\"note1\":\"6\",\"stationid\":\"31003\",\"numbikes\":\"6\",\"bikesreported\":5,\"numbroken\":3},\"geometry\":{\"spatialReference\":{\"wkid\":4326},\"x\":-77.049593,\"y\":38.86017,\"z\":null}}"

-----------------

json.loads(row[1]):

{"attributes":{"note1":"6","stationid":"31003","numbikes":"6","bikesreported":5,"numbroken":3},"geometry":{"spatialReference":{"wkid":4326},"x":-77.049593,"y":38.86017,"z":null}}

-----------------

json.loads(json.loads(row[1])):

{u'geometry': {u'y': 38.86017, u'x': -77.049593, u'z': None, u'spatialReference': {u'wkid': 4326}}, u'attributes': {u'note1': u'6', u'stationid': u'31003', u'numbroken': 3, u'bikesreported': 5, u'numbikes': u'6'}}

If you further assistance debugging, I'd suggest opening a technical support case- it would be a bit easier than to debug remotely via GeoNet.

Re: Send Error Code 400

CarlHolt1 — Fri, 09 Dec 2016 18:59:39 GMT

I am also having this same issue, but only on iPads. I have republished the survey, downloaded the updated survey, began a new survey and still get the error.

The odd thing is if I do this same routine using Survey123 for Windows, I get no error.

Re: Send Error Code 400

JamesTedrick — Fri, 09 Dec 2016 22:21:34 GMT

Hi Carl,

To diagnose, can you try logging into your organization on the iPads and attempt to add the feature service of the survey to a map?

Re: Send Error Code 400

CarlHolt1 — Mon, 12 Dec 2016 14:15:30 GMT

I have a Collector app that I am using the custom attribute to link to the Survey and pull over fields. The feature service, created from the survey, is in the Collector map.

Re: Send Error Code 400

CarlHolt1 — Wed, 01 Mar 2017 16:26:45 GMT

The survey that has the Error 400 had to be republished, but I renamed it the same as the old. Could this be causing confusion on the iPad App that does not allow users to send, but only me (admin) when I am logged in?

Re: Send Error Code 400

JamesTedrick — Wed, 01 Mar 2017 18:23:06 GMT

From your description, I'm a little unclear- are we talking about users attempting to submit data on an iPad unsuccessfully and then you are able to submit data when you are logged in on the same iPad? If so, it sounds like a sharing issue. The republishing might have caused that; you may want to double-check the sharing settings of the Feature Layer and Form from the ArcGIS Online 'My Content' interface.

Re: Send Error Code 400

CarlHolt1 — Wed, 01 Mar 2017 18:25:57 GMT

Shared to the group.

I am going to publish the same survey, under a different name and see if the issue can be replicated.

Re: Send Error Code 400

CarlHolt1 — Wed, 01 Mar 2017 18:43:01 GMT

I created a new survey, different name, same xls form. User was able to send the survey no problem. So it is a republishing issue where the Suvery123 App is confused by the url and looking for the old form, feature layer (of the same name) as the newer published form.

Re: Send Error Code 400

CarlHolt1 — Wed, 01 Mar 2017 20:17:03 GMT

James,

Yes I am able to send the survey's without getting Error 400 when I(admin) am signed in. The issue has to be the survey I deleted, copied the XLS form, and created a new survey (in Connect) using the same XLS scheme with the same name. I tested this theory and it conclude that has got to be the issue. Now, I am looking for guidance from y'all on how to move the data from the existing form and feature layer to a new survey (with the same exact XLS scheme.)