Import Table with all fields of Target table

[dshamatr]

Hello!

I have a question.

Is that possible to create Import Table with all fields of Target table?

For example, I have change_request table as target for my Import Table. Now, my table extends sys_import_set_row.

I inserting data into my Import Table using REST API. Previously we used change_request.do as endpoint to insert Change Requests directly.

Now we're moving to Import Tables and Transform Maps and we need to have possibility to use all fields that present in Change Request table by default.

Also, we want to avoid manual field creation.

Is there a way to create in my Import Table automatically all fields that present in the change_request table?

Or how it should be done properly?

Thanks.

/Dmitriy

[tft]

ServiceNow usually ingores the target table out of the box.   To import fields to a specific table you need to update a system property in servicenow.

Go to sys_properties.list

Search for 'glide.import_template.field_types_to_ignore'

In the Value field, remove 'table_name'.

Once that is removed, imports should be looking for what table your importing too.  

I know this works on simple imports but I would have to believe this may help with your REST API imports since system properties are system wide.

Hope this helps,

Thanks,

Tallal Tawil