I am using vendor api to let SAP vendor master data synchronize with Concur. But I am facing a problem with list fields.
My Target flow
Step 1. Use Vendor API Get to retrieve unapproved vendor information from Concur and put it into SAP vendor master
Step 2. Extract vendor info from SAP and Use Vendor API Post or Put to update vendor as approved vendors, meanwhile matching approved vendors with original unapproved vendor by AddressImportSyncID.
I can only retrieve Value from custom field if it is a list field.
i.e. Bank Key in SAP: code - 1234567 / value - Bank of Japan
Bank Key in Concur: code - 1234567 / value - Bank of Japan
When I retrieve vendor by API Get in Step 1, what I get from Vendor API Get is “Bank of Japan”, instead of 1234567.
But I only need 1234567 to input in SAP.
And actually, if I use “Bank of Japan” in Step 2, it will fail since Concur only accept code when import vendor.
I am wondering if anyone has the same problem and would appreciate if you can share the solution.