import a JSON file into ServiceNOW
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2024 08:52 AM
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