Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Using this RTE, I would like to create as many records as there are fields

HS7
Giga Guru

Hi,

The import set table has the following data:

[Field]=[Value]
name1=test_name1
name2=test_name2
name3=test_name3

 

Using this RTE, I would like to create the following records in table A:

record1
name=test_name1,
record2
name=test_name2,
record3
name=test_name3

 

How can I implement this?
2 REPLIES 2

Ricardo26
Tera Guru

Hi,

 

A possible solution would be format the original payload to the expected pattern via script. Ex:

[{ name1: "test_name1"}, { name2: "test_name2"}] => [{ name: "test_name1"}, { name: "test_name2"}] 
After format, you run the RTE.

 

If it's useful, please mark it as correct

@Ricardo26 
Hi,thank you.
In the import set table, each record has fields named 1 to 3.
I would like to create the data by dividing it into three records in table A.

Can it be achieved this way?