API Import Set "sysparm_transform_after_load=true" Not Working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-14-2024 10:44 AM
We are moving to a new instance, and I am trying to migrate the integration to the new one. We have an existing API call from an outside software that is using this "https://<instancename>.service-now.com/sys_import.do?sysparm_import_set_tablename=u_import_interfaces&sysparm_transform_after_load=true"
The "sysparm_transform_after_load=true" works fine in our old instance. It auto-triggers the transform maps and maps the data over.
However, the new instance does not auto-triggering the transform maps. Everything from the data source, transform maps, and the user account is the same as the old instance.
In case you are wondering, my roles on the user account are (import_admin, rest_api_explorer, rest_service, sn_hr_core.admin, and soap). I have sn_hr_core.admin because some data sources are written to the HR profile.
Any help would be greatly appreciated!
Old Instance:
New instance:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-14-2024 01:18 PM
Have you tried doing a test load of 20 records in the new instance? If not, maybe you need to try that first and then try to import and transform via direct URL.
Can you test it with other import sets and see if others are impacted? There seems to be something missing because it should work for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-23-2024 08:01 AM
@The Machine I tried that, and it didn't work either. I ended up putting a HI ticket and waiting on the rep to get back to me about it. More to come, hopefully.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2024 11:06 AM
Could you post what ServiceNow said? Thanks