Load data from a JSON file in to ServiceNOw

JohnDoe2
Tera Contributor

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

JohnDoe2_0-1706708972051.png

 




0 REPLIES 0