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.

[Mike Patel]

instead if staging_table use table_name and see if you get same error.

[brian_degroot]

Hi Jamie,

The only available tables that can be used with Import Set API are extensions of sys_import_set_row. Can you check the entry for your table in sys_db_object and make sure this is the case?

Thank you,

-Brian

[Jamsta1912]

Hi Brian,

Thank you for your response. I just checked this, and yes the table does extend sys_import_set_row.

Jamie

[Nithish1]

Hi Jamie,

Can you verify that staging table has create, read, write ACL's in place?

Thanks,

Nithish