import a JSON file into ServiceNOW

beycos
Tera Contributor

Hello Community, 

I would like to import a JSON file into ServiceNow. The Json file is as follows;

{
"$schema": "../bbbb_dddd.json",
"bbType": "BC",
"schemes": [
{
"name": "A0",
"surname": "A0",
"adress": "AI",
"companyNumber": 0
}
]
}

First, I created a data source, and when I filled in the path for each row as /schema/schema, I got the error 'No fields provided for mapping to headers.' However, when I filled in the path for each row as /schemes/schemes, I was able to create the transform map, but the transform map does not include bbtype. That's because the bbType field isn't contained in the schemes, but in the header of the schema. How can I include the bbType field in the transform map, or how can I import bbType into ServiceNow?

Thank you in advance for your help.

Kind Regards, 

Beyza 

 

 

 

0 REPLIES 0