Developer forum

Forum » Dynamicweb 10 » Using Code in column mapping to determine ID

Using Code in column mapping to determine ID

Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Hi guys,

I have an integration job where I get the name of a Stock location from NAV (instead of StockLocationID).
Is there any way I can use the Code section of the mapping to identify the corresponding StockLocationID instead of creating a Table Scripting?

Thank you,

Adrian

 


Replies

 
Rasmus Sanggaard Dynamicweb Employee
Rasmus Sanggaard
Reply

Hi Adrian,

 

Have you looked at custom script types? https://doc.dynamicweb.dev/documentation/extending/integrations/scripttypeprovider.html?q=scripting#4-product-number-to-product-id

 

BR Rasmus Sanggard

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Hi Rasmus,

Thank you for the detail. That is the "Old" Table scripting, right?

I was trying first to see if the Code option could help me without compiled code. But if Table scripting is the way to go, I will go that way.

Thank you,
Adrian

 

 
Rasmus Sanggaard Dynamicweb Employee
Rasmus Sanggaard
Reply

Hi,

 

No, this is a way to make your own (column) script types. So in the example in the link it looks up and returns a ProductId based on a provided ProductNumber. Take a look at the documentation provided, and see if that isn't the way forward in your scenario.

 

BR Rasmus Sanggaard

 

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Great!

Thank you.
Adrian

 

You must be logged in to post in the forum