Developer forum

Forum » Ecommerce - Standard features » Best way to pull selected shop ID from Shipmondo

Best way to pull selected shop ID from Shipmondo

Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

Hi there,

I have a site using Shipmondo. As part of the checkout process it captures a shop ID which is stored in OrderShippingProviderData in a format like this:

{    "ShipmondoCarrierProductCode": "GLSDK_SD",    "ShipmondoServicePointId": "96757",    "ServiceSelectedDataCarrierName": "GLS Denmark",   ..more here }

Now during OData integration, I need to capture the ShipmondoServicePointId and send it on to an OData endpoint.

What's the best way to do this? Am I better off capturing this in the frontend and store in a custom order field? Or is there a way to parse this data duing OData integration?

Thanks!

Imar


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

Oh, just relized that JSON_VALUE works just fine:

JSON_VALUE(OrderShippingProviderData, '$.ShipmondoServicePointId') AS ShipmondoServicePointId

Imar

 

You must be logged in to post in the forum