Record value are not inserting in Reference field through integration EMERGENCY

ARAVINDA11
Tera Contributor

@Ankur Bawiskar  @Community Alums  @Sohail Khilji  @Maik Skoddow 

 

Please help me I have reference field in PO Table which is configured with CORE__COMPANY TAble

In general if I type vendor code in reference field it is reading the value and setting in the field

 

The same if i pass the vendor code through integration via flow the record is inserting as a blank I can see the same vendor code is available in corr_company table why it is not inserting with the existing name value of company

 

ARAVINDA11_0-1718872599047.png

 

4 REPLIES 4

Slava Savitsky
Giga Sage

The [i] icon next to the Vendor field suggests that the field is not empty, but rather contains a value that is not a valid sys_id and a sys_id that does not exist in the table, which the reference field is pointing to. Check the XML view of the record to see what value is actually stored in the Vendor field at the database level.

In XML it has the vendor code value why it is not displaying the correct name why it is blank

SEE MY XML It is passing empty value 

ARAVINDA11_0-1718876249921.png

 

It is because Vendor is a reference, a not a string field. You need to look up the sys_id of the appropriate Company record and put that sys_id into your Vendor field instead of the vendor code.