question Re: Field mapping string field to reference field in Developer forum

Field mapping string field to reference field

Sathiskumar_D — Sun, 15 May 2022 22:27:59 GMT

Hello,

I have JSON data in the Staging table field.

I have to map with reference field in table.

But transformation is not working as anticipated. Could someone help me ?

I've also referred other community questions.

https://community.servicenow.com/community?id=community_question&sys_id=b8f93179db0c67c01cd8a345ca9619eb

https://community.servicenow.com/community?id=community_question&sys_id=83ed1ac4db2c90104819fb2439961950

Re: Field mapping string field to reference field

Hitoshi Ozawa — Mon, 16 May 2022 01:47:23 GMT

Hi Sathish,

The function should return the value to enter into the field.

answer = (function transformEntry(source) {
  var accnttype = JSON.parse(source.u_gen_prod_info);
  if (accntType.product == 'Mortgage') {
    return lprod;
  }
})(source);

Re: Field mapping string field to reference field

Ankur Bawiskar — Mon, 16 May 2022 03:41:01 GMT

Hi,

in the field map script you need to parse the JSON

also while returning you need to return value which is stored in u_gen_prod_info

Regards
Ankur

Re: Field mapping string field to reference field

Sathiskumar_D — Mon, 16 May 2022 12:03:31 GMT

Hi Ankur,

But TYpe of Account (mapping field) has to refer "Loan product" but not u_gen_product_info.

Re: Field mapping string field to reference field

Ankur Bawiskar — Tue, 17 May 2022 03:55:27 GMT

please return the value which you wish to be searched in the field u_gen_prod_info of the table being referred by Type of Account field

Regards
Ankur

Re: Field mapping string field to reference field

Sathiskumar_D — Wed, 18 May 2022 14:35:48 GMT