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.

how to set reference to another entity in a Robust Transformer

ashrafi
Tera Contributor

Hi All,

I am inserting the a record in two separate table using robust transform map, but facing one issue of Reference field.

eg:- Table A has a reference field which is refer to table B. I want to set the sysId of record created in table B to the reference filed of Table A.

Any suggestion will be valuable ...

9 REPLIES 9

ersureshbe
Giga Sage
Giga Sage

Hi, TableB value when you are going to set TableA reference field. If you explain clearly, i will try to help you.

Regards,

Suresh.

Regards,
Suresh.

Using robust Map I am storing the record in two table i.e  Table A and Table B.

Table A has reference field name as (Group ID), now I want to set the Sys_ID of newly created record in table B to the GroupId field of Table A via robust transform map.

Please let me know who Table A and Table B record os creating both are creating simultaneously. 

Are you using the import set table concept to create/update the record in target tables?

Regards,

Suresh.

 

 

Regards,
Suresh.

sc
Tera Contributor

@sureshloganathan I'm struggling with the same problem. Using RTE (Robust transformer) I'm creating records to two tables (cmdb_ci) and (cmn_location). The problem is with creating relations (set location field with value of newly created cmn_location). I have tried to set Referenced entity pointing to location on cmdb_mapping (location field), but still this field isn't populated. 

If you can share update set with working example, I would be grateful.

Regards,
Piotr