topic Re: pull data function returning 400 Invalid URL in ArcGIS Survey123 Questions

topic Re: pull data function returning 400 Invalid URL in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/pull-data-function-returning-400-invalid-url/m-p/1327130#M51632 <P>Good news, it's working. Bad news, I'm not sure what exactly happened.</P><P>What I think happened is that there is some sort of disconnect between the code in the script window and the js file in the scripts folder. What I ended up doing was l tried to launch the script in an editor and then made changes. It just seemed to flip a switch or something and then the survey worked as expected.</P><P> </P> Mon, 11 Sep 2023 01:39:10 GMT MichaelKohler 2023-09-11T01:39:10Z pull data function returning 400 Invalid URL https://community.esri.com/t5/arcgis-survey123-questions/pull-data-function-returning-400-invalid-url/m-p/1327113#M51631 <P>Hi,</P><P>I've been using the Damage Assessment Solutions that includes Survey123 Connect XLS forms. Part of that is the JavaScript functions that should pull data from a feature service and use the data to populate a field in the survey. I keep getting a 400 error saying the URL is invalid. I've even created a URL that I know works and short circuited the JavaScript code and still get the invalid URL error. I've had this working in other surveys, just not the damage assessment.</P><P>This is how the function is called from the XLS</P><LI-CODE lang="markup">pulldata("@javascript","myJSFunctions.js","queryPolygon",string(${location}),"PARCELID",pulldata("@property","token"),true)</LI-CODE><P> </P><P>Below is the code in the scripts folder. </P><P> </P><P> </P><LI-CODE lang="javascript">function queryPolygon(location,fields,token,debugmode){ if (location===""){ return (debugmode? "Location Object is empty":""); } var featureLayer = "https://services1.arcgis.com/**********/arcgis/rest/services/RE_PARCELS_WEB/FeatureServer/0"; var coordsArray = location.split(" "); var coords = coordsArray[1] + "," + coordsArray[0] var xmlhttp = new XMLHttpRequest(); var url = featureLayer + "/query?geometry=" + coords + "&geometryType=esriGeometryPoint&inSR=4326&spatialRel=esriSpatialRelIntersects&outFields=" + fields + "&returnGeometry=false&returnCount=1&f=json" if (token){ url = url + "&token=" + token; } xmlhttp.open("GET",url,false); xmlhttp.send(); if (xmlhttp.status!==200){ return (debugmode? xmlhttp.status:""); } else { var responseJSON=JSON.parse(xmlhttp.responseText) if (responseJSON.error){ return (debugmode? JSON.stringify(responseJSON.error):""); } else { if (responseJSON.features[0]){ return JSON.stringify(responseJSON.features[0]); } else{ return (debugmode? "No Features Found":""); } } } }</LI-CODE><P> </P><P> </P><P> This is the error that is stored in the JSON field. See Picture</P><P>{"code":400,"message":"Invalid URL","details":["Invalid URL"]}</P><P>Then I created a url that I know works and hardcoded it into the code and still get the same error.</P><P> </P><P> </P><LI-CODE lang="javascript">function queryPolygon(location,fields,token,debugmode){ if (location===""){ return (debugmode? "Location Object is empty":""); } var featureLayer = "https://services1.arcgis.com/***********/arcgis/rest/services/RE_PARCELS_WEB/FeatureServer/0"; var coordsArray = location.split(" "); var coords = coordsArray[1] + "," + coordsArray[0] var xmlhttp = new XMLHttpRequest(); var url = featureLayer + "/query?geometry=" + coords + "&geometryType=esriGeometryPoint&inSR=4326&spatialRel=esriSpatialRelIntersects&outFields=" + fields + "&returnGeometry=false&returnCount=1&f=json" //short circut url with known url that works when pasted into browser. var url = "https://services1.arcgis.com/**********/arcgis/rest/services/RE_PARCELS_WEB/FeatureServer/0/query?geometry=-80.39273,27.21473&geometryType=esriGeometryPoint&inSR=4326&spatialRel=esriSpatialRelIntersects&outFields=PARCELID&returnGeometry=false&returnCount=1&f=json" if (token){ url = url + "&token=" + token; } xmlhttp.open("GET",url,false); xmlhttp.send(); if (xmlhttp.status!==200){ return (debugmode? xmlhttp.status:""); } else { var responseJSON=JSON.parse(xmlhttp.responseText) if (responseJSON.error){ return (debugmode? JSON.stringify(responseJSON.error):""); } else { if (responseJSON.features[0]){ return JSON.stringify(responseJSON.features[0]); } else{ return (debugmode? "No Features Found":""); } } } }</LI-CODE><P> </P><P> </P><P> </P><P>Any ideas would be greatly appreciated. As well on what the debug mode is and how would someone debug this code.</P><P> </P> Sun, 10 Sep 2023 14:57:19 GMT https://community.esri.com/t5/arcgis-survey123-questions/pull-data-function-returning-400-invalid-url/m-p/1327113#M51631 MichaelKohler 2023-09-10T14:57:19Z Re: pull data function returning 400 Invalid URL https://community.esri.com/t5/arcgis-survey123-questions/pull-data-function-returning-400-invalid-url/m-p/1327130#M51632 <P>Good news, it's working. Bad news, I'm not sure what exactly happened.</P><P>What I think happened is that there is some sort of disconnect between the code in the script window and the js file in the scripts folder. What I ended up doing was l tried to launch the script in an editor and then made changes. It just seemed to flip a switch or something and then the survey worked as expected.</P><P> </P> Mon, 11 Sep 2023 01:39:10 GMT https://community.esri.com/t5/arcgis-survey123-questions/pull-data-function-returning-400-invalid-url/m-p/1327130#M51632 MichaelKohler 2023-09-11T01:39:10Z