Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

Error during the Import using datasource

Nithya Devi
Tera Contributor

Dears friends,

 

When I do import on Contact files through the Data Source,throwing some errors.Could anyone help to fix this error to run smooth transform.

NithyaDevi_0-1749646951493.png

 

1 ACCEPTED SOLUTION

@Nithya Devi 

nope, it will reject.

As per your screenshot the Choice action is reject, that's what I informed earlier

That's the reason the entire row is rejected.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

3 REPLIES 3

Ankur Bawiskar
Tera Patron

@Nithya Devi 

the error clearly says record was rejected as company was not found

Did you check the field map for company target field?

Since company field on sys_user is Reference, the choice action must be set as "Reject"

When there is no matching company found then that row will be rejected

AnkurBawiskar_0-1749647784734.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

NithyaDevi_0-1749648104665.png

As per choice action,it has to ignore/skip the change.but it is throwing an error.

Source field-erpVendorId (Import set table)

Target field-Vendor(company)(Contact table)

reference field- u_erp_vendor_id (refering to Company table).

 

@Nithya Devi 

nope, it will reject.

As per your screenshot the Choice action is reject, that's what I informed earlier

That's the reason the entire row is rejected.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader