Import Set API - Invalid Table

[Jamsta1912]

Hello all,

I have created a web services table and I'm trying to post data to it using the import set API. I'm using a URI of this style:

https://myinstancedev.service-now.com/api/now/import/u_my_inbound

I can see that the table name is correct but when I post I get this response:

{
"import_set": "ISET0017916",
"staging_table": "u_my_inbound",
"result": [{
"transform_map": "",
"status": "error",
"error_message": "Invalid table "
}]
}

Other details, such as the username/password and the JSON in the request body are also valid. I have a transform map set up, which targets the incident table.

I'm only getting this issue with this one particular table. I have other integrations in place already for incident but I don't get the error message when I post to those tables.

It may just be a glitch in the matrix and one solution might be to just rebulid the table and transform map from scratch, but I'd like to avoid that if possible!

Can anyone advise what might be causing this error?

Thank you

Jamie.

[Jamsta1912]

Hi Nithish,

Yes there are create, read and write ACL's in place for the table. I have tried posting as a user with specific access against those ACLs and also as an admin user, but with the same result.

Regards

Jamie

[Nithish1]

Hi Jamie,

Can you try getting to the table list view with admin and with the rest user?

Can you make sure rest user has "import_set_loader" and "import_transformer" roles as well?

Thanks,

Nithish

[Jamsta1912]

Ah, I've found what the issue is.

Actually it was nothing to do with the staging table itself, but with the transform map, and specifically one particular field map.

I am using a variation of this script to conditionally coalesce:

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/import-sets/conce...

I had added an encoded query and found a sytax error: an extra semi-colon. This was causing the whole transformation to fail, though the 'invalid table' message was confusing.

Thank you both for your help.

Jamie.