Conversion of List Lookup Values

Nextworld Platform
,
1

I have some integration code where I will get a value from an external system and I need to map to a list lookup value into ERP. For example, I would get type: “Fleet” from the external system but I need to map it to “FLEET” to ERP. Is there a best practice of doing this? Currently, I am thinking I need to write a bunch of if statements for each possible list lookup value and mapped to ERP in uppercase via Text Manipulation action. But it seems not a good long term solution in the Maintainability perspective.

2

If this is in context of a Data Import or Data Export, the List Lookup Cross Reference Utility serves the purpose you’re asking for.

However if it’s a REST integration you’re working with, as far as I’m aware you’ll need to currently do this through logic.

image
image2980×609 104 KB

3

Unfortunatley, I am doing it as part of REST integration. It would be nice if it can be done at the endpoint response mapping step when defining the response to NW field mapping. I guess I have no other choice at this point. Thanks.