Data Source doesn't show up in list of tables

[kevin_leuthold]

In my personal developer instance, I create a data source according to these instructions:

https://docs.servicenow.com/bundle/kingston-platform-administration/page/administer/import-sets/task/t_CreateNewDataSource.html.

The name of my table is u_application_import. I'm planning to use it to import applications using the Import Set REST API.

But, when I go to create a transform map from u_application_import to cmdb_ci_appl, my table doesn't show up in the source table drop-down. It also doesn't show up in the list of tables in the REST API explorer for the Import Set API. Finally, when I try to call the API to post a record to the table, I get the following error message back:

{"detail":"Specified table does not extend 'sys_import_set_row'","message":"Invalid staging table"}

I've done all this before successfully, and I think I'm following the right steps. I wiped out my developer instance recently and needed to set up everything again. So I'm baffled as to why it's not working this time. What am I doing wrong??

[Shishir Srivast · Accepted solution]

Can you please try to use load data module to load the CSV file

 

and then navigate to Data Source to check the loaded file and i think there you can test and set the transform. Please check if this helps.

[kevin_leuthold]

Shishir, thank you so much for your help! This worked great and is exactly what I need.