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??

[Ahmmed Ali]

Hello,

Does the table u_application_import extends "sys_import_set_row" table ?

the source table for transform amp should extend the above mentioned table.

Thanks,

Ali

[Shishir Srivast]

How did you create the table, you can create, you can use the Inbound WS to create a staging table.

[kevin_leuthold]

Ali and Shishir, thank you for your responses!

I am creating the table in System Import Sets -> Data Sources.

Ali, not only does the table that I create not extend "sys_import_set_row", it doesn't even seem to exist after I create it. It will show up in the list of Data Sources, but when I search for it under System Definition -> Tables by the name or label I gave it, it is not there. But I am pretty sure that I was able to create the import tables in this way in the past. I'm wondering if I'm encountering a bug?

Shishir, thank you for your suggestion. I did not know until now that creating a web service would automatically create a REST endpoint. Although we would only use the REST API, not the web service, this could be a way for us to go. Do you know if there is a way to load the column names instead of creating them manually? I know I could copy them from the target table, but the way I was doing it before (by creating a Data Source) allowed me to create columns by uploading a CSV file with only the header row (column names).

Edit: removed attachment and added screenshot as image below.

[kevin_leuthold]

Here is the screenshot of how I created a new Data Source. Notice the required field "Import set table name". This table then never existed in the list of tables in the System Definition.