Load data from a JSON file in to ServiceNOw
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2024 05:50 AM
HI FOlks ,
I am trying to Migrate data from a different system into ServiceNow's Case table -
The data is in JSON format and I am using Data source to load the data .
The JSON format of the data for a single case record is -
{
"Queue": "ServiceDesk",
"indexingInternalField":[{},{}],
"auditHistoryGrid":[{},{},{}],
"fileList":[{},{},{}],
"QueuesTraversed":[],
"IndexingField":[{},{},{}]
}
Where FileList contains attachments , auditHistorygrid contains History of changes , IndexingField Contains objects with Fieldnames and values .
My Question is How can I define a path for each row to load all data ?
I tried giving the path as "//" but it throws error saying header fields are not defined