All was great and I was able to pass data into the custom table. However, then I went to ServiceNow and I added in additional columns to that custom table. The original activity that I pulled in continues to work. I was able to refresh the activity and the new column fields appeared. However, if I drag in an entirely new insert record, the table I want no longer appears:
So in short, the old activities still function but the new ones (post SNow custom table update no longer work). If I was just using “insert record” I would just copy and paste the existing activity and move on. However, I need to use “Update Record” so it wont work. Please let me know!
Ensure each “Insert Record” activity points to the correct table/object and refresh them in Studio to update the schema. Wrap the activities inside a ServiceNow Application Scope, if needed, clear Studio’s cache. If new columns still don’t appear, use the HTTP Request activity to insert records via ServiceNow’s REST API.
Something else of interest. When i deleted the locals folder the existing activities that once worked stopped working. the activities now show this error:
The object ‘x_renewals_table’ is no longer accessible on the current connection. Please verify your permissions, or choose a valid object from this connection, or select a connection that includes this object. Error code: DAP-DT-2002."
Anil brought my attention to this topic as I was helping someone on another post that had a similar issue related to JIRA.
We were able to quickly confirm that, at least with JIRA, there is definitely a bug where you cannot see the properties in the activity card in order to load the dynamic properties.
It seems to be exactly the same as your issue with ServiceNow, I just don’t have a Service Now Sandbox to test with, I raised it directly with the product manager for the Integration Service as it seems like a pretty serious issue. Hopefully it will get clearly identified and fixed urgently and the same fix for JIRA will fix yours too.