topic Re: Adding a row to a table using JS 4.x in ArcGIS JavaScript Maps SDK Questions

Adding a row to a table using JS 4.x

Mr_Kirkwood — Wed, 20 Nov 2024 16:53:14 GMT

I was using JS 3.x to add and update data. I am working on convert my applications to JS 4.x. I had a script that used "dojo/Deferred". Here is the code:

How do i make this work in JS 4.x?

Thank you in advance for any help on this.

Re: Adding a row to a table using JS 4.x

JoelBennett — Wed, 20 Nov 2024 18:11:22 GMT

You should use the native Promise object instead. Here is what the above code would look like using it:

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Wed, 20 Nov 2024 22:34:28 GMT

Thank you, Joel, for helping. I am now getting this error message:

4.30/:31 Error: scriptError: https://js.arcgis.com/4.30/esri/graphic.js

src: dojoLoader

info: (2) ['https://js.arcgis.com/4.30/esri/graphic.js', Event]

Thanks in advance!

Re: Adding a row to a table using JS 4.x

JoelBennett — Wed, 20 Nov 2024 22:45:45 GMT

I thought you were asking specifically about the replacement for dojo's Deferred module. To migrate the whole function, you'll also need to update the use of FeatureLayer and Graphic for compatibility with 4.x:

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Wed, 20 Nov 2024 23:12:13 GMT

Thank you! That works. I really appreciate your help.

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Thu, 12 Dec 2024 18:21:36 GMT

Joel,

If i want to delete or just edit do i change this line:

featureLayer.applyEdits({addFeatures:graphicsArr})

to deleteaFeatures and editFeatures?

Re: Adding a row to a table using JS 4.x

JoelBennett — Thu, 12 Dec 2024 18:56:18 GMT

To edit features, you would use:

featureLayer.applyEdits({updateFeatures:graphicsArr})

To delete features, you would use:

featureLayer.applyEdits({deleteFeatures:graphicsArr})

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Thu, 12 Dec 2024 19:24:31 GMT

That is what i thought. i had been trying it but was getting this error:

ERROR! e {name: 'request:server', details: {…}, message: 'Unable to complete operation.'}details: getAllHeaders: ()=>Array.from(Z.headers)getHeader: ra=>Z.headers.get(ra)httpStatus: 500messageCode: undefinedmessages: ["No edits ('adds', 'updates', 'deletes', 'attachment edits', or 'asset maps edits') were specified."]raw: {code: 500, message: 'Unable to complete operation.', details: Array(1)}requestOptions: {method: 'post', query: {…}, responseType: 'json'}ssl: truesubCode: undefinedurl: "https://uwoperations.uwyo.edu/hostgis/rest/services/REO/REV_UWOPS_EditRooms/FeatureServer/1/applyEdits"[[Prototype]]: Objectmessage: "Unable to complete operation."name: "request:server"[[Prototype]]: ctype: "error"constructor: class etoJSON: toJSON(){if(null!=this.details)try{return{name:this.name, message:this.message,details:JSON.parse(JSON.stringify(this.details,(d,p)=> {…}[[Prototype]]: Object

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Thu, 12 Dec 2024 20:33:59 GMT

joel,

I got it to work. I was forgetting to grab the OBJECTID for the edit and delete. Thanks again!

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Wed, 05 Mar 2025 18:04:03 GMT

How would i be able to pass multiple OBJECTIDS to edit in batch with the code above?

here is what i am using to grab information from a popup window:

Re: Adding a row to a table using JS 4.x

JoelBennett — Fri, 07 Mar 2025 20:08:36 GMT

If you want to set multiple features to have the same attribute values, you could do so with a function like this:

You would then determine the records you want to update, and create an Array of their objectID values:

var objectIds = [1,2,3,4,5];

Then you could call the function:

_applyUpdates(roomsTable, editRoom, objectIds);

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Fri, 07 Mar 2025 19:38:37 GMT

Joel,

I am getting this error:

Uncaught (in promise) ReferenceError: features is not defined

at this line

featureLayer.applyEdits({updateFeatures:features}).then(

Re: Adding a row to a table using JS 4.x

JoelBennett — Fri, 07 Mar 2025 20:09:05 GMT

My bad, line 16 above should be:

featureLayer.applyEdits({updateFeatures:featureSet.features}).then(

I'll change it in that post too.

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Fri, 07 Mar 2025 20:20:08 GMT

Thanks! However, i am getting a new error. I cxan edit a single record so not sure what is going on?

baseQueries.js:120 ERROR! e {name: 'request:server', details: {…}, message: 'Unable to load https://uwoperations.uwyo.edu/hostg…EditLayers/FeatureServer/9/applyEdits status: 500'}

Re: Adding a row to a table using JS 4.x

JoelBennett — Fri, 07 Mar 2025 20:32:01 GMT

Are you able to log into ArcGIS Server Manager for that instance? If so, the logs may contain more information.

Re: Adding a row to a table using JS 4.x

RobertKirkwood — Fri, 07 Mar 2025 21:28:17 GMT

The logs report this:

"Error executing tool. ReportCacheStatus : ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. ArcGIS Server requires a service type (ParentType) and a server object extension type (Type). Failed to execute (ReportCacheStatus)." - System/ReportingTools.GPServer

I will see if i can track down this error. Seems odd it works on a single record. Console reports it is happening at this line:

featureLayer.applyEdits({updateFeatures:featureSet.features}).then(

next line it fails is:

featureLayer.queryFeatures().then(function(featureSet) {

then:

return new Promise(function(resolve, reject) {

and lastly:

_applyUpdates(roomsTable, batchEditRoom, objectIds).then (function ()

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Fri, 07 Mar 2025 22:33:20 GMT

The logs report this:

I will see if i can track down this error. Seems odd it works on a single record. Console reports it is happening at this line:

featureLayer.applyEdits({updateFeatures:featureSet.features}).then(

next line it fails is:

featureLayer.queryFeatures().then(function(featureSet) {

then:

return new Promise(function(resolve, reject) {

and lastly:

_applyUpdates(roomsTable, batchEditRoom, objectIds).then (function ()

Re: Adding a row to a table using JS 4.x

JoelBennett — Sat, 08 Mar 2025 01:31:42 GMT

A few things to check:

1) Make sure this data is going to the right layer in the service.

2) Make sure all the fields are named correctly and exist in the service. Field names are case sensitive.

3) The OBJECTID field shouldn't be included in the attributes you capture from the form. Lines 9 and 10 in the code I wrote are supposed to strip it out if it's present. I suppose the server could generate an error if multiple update records were supplied with the same objectID values. For reference, since it's on a different page now, here's the code where you capture the values from the form:

editRoom.OBJECTID = Number (roomObjectID) editRoom.ADA = document.getElementById ('roomDetails-ADA').value; editRoom.CAPACITY = document.getElementById ('roomDetails-CAPACITY').value; editRoom.SPACETYPECAT1KEY = document.getElementById ('roomDetails-SPACETYPECAT1KEY').value; editRoom.SPACETYPECAT2KEY = document.getElementById ('roomDetails-SPACETYPECAT2KEY').value; editRoom.SPACEUSECAT1KEY = document.getElementById ('roomDetails-SPACEUSECAT1KEY').value; editRoom.SPACEUSECAT2KEY = document.getElementById ('roomDetails-SPACEUSECAT2KEY').value; editRoom.DESCRIPTION = document.getElementById ('roomDetails-DESCRIPTION').value; editRoom.CAPACITY = document.getElementById ('roomDetails-CAPACITY').value; editRoom.ASSIGNABLE = document.getElementById ('roomDetails-ASSIGNABLE').value; editRoom.NOTES = document.getElementById ('roomDetails-NOTES').value; editRoom.USABLE = document.getElementById ('roomDetails-USABLE').value;

Re: Adding a row to a table using JS 4.x

Mr_Kirkwood — Mon, 10 Mar 2025 16:27:42 GMT

Joel,

let me see if this is what you mean here is the Batch Edit function that i use to pass to the _applyUpdates:

I grab the OBJECTIDs from the table of the selected records . I still seem to be getting an error . I am only using the NOTES field for this test, by the way.

Re: Adding a row to a table using JS 4.x

JoelBennett — Tue, 11 Mar 2025 23:21:43 GMT

That looks fine as far as I can tell. You might want to check out the Network Tab of the developer tools and look into the details of the request sent to applyEdits. Particularly, check out the payload to make sure everything looks proper in there.