Scripted Web Service requiring a transform map?

[SC17]

Hello. I am developing a Scripted Web Service. I am sending a payload to a custom table that is extending the table Import Set Row. Because of this, I am getting the following error: Transform map record not provided, transform stopped: no thrown error.

Is there a way to bypass this?

Thank you.

[Pavankumar_1]

Hi @SC17 ,

Import set table requires a transform because we can't build relationships  with target without transform map.

I think we can't connect import set table and scripted rest API.

[Amit Gujarathi]

Hi @SC17 ,
I trust you are doing great.

The error message you're receiving is indicating that the transform map is missing for your custom table. A transform map is a tool that maps the fields of an import set table to fields in a ServiceNow table. Without a transform map, ServiceNow doesn't know how to map the fields of your custom table to the fields in the Import Set Row table.

To resolve this issue, you will need to create a transform map for your custom table that maps its fields to the fields in the Import Set Row table. You can create a transform map by following the steps below:

1. Navigate to System Import Sets > Transform Maps.
2. Click the New button.
3. Fill in the required fields on the form. Be sure to select the correct target table (Import Set Row) and source table (your custom table).
4. Click Submit.
5. On the Field Maps related list, map each field in your custom table to the corresponding field in the Import Set Row table.
6. Click Save.

Once you've created the transform map, you should be able to send a payload to your custom table without encountering the error message.