Developer forum

Forum » Integration » Json Destination Provider

Json Destination Provider

E-mail notifications
Carolee Schuck Dynamicweb Employee
Carolee Schuck
Reply
Posted on 22/11/2021 16:23:17

Hi!

I need to export orders from Dynamicweb to Json with order lines as a subschema of each order.  Is this possible?

I'm using "Dynamicweb with Views" for the source provider.

Thanks,
Carolee


Replies

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Posted on 22/11/2021 17:57:15
Reply

Hi Carolee,

 

This is tricky because the JSON provider simply outputs the data in JSON format, and what you're looking for is to refactor the data into a specific JSON format.

 

That said, maybe what you can do is:

  • Likely use the Order Provider so you get everything in a flat format (order header + orderline)
  • Use XML Provider to export
  • Use XSLT to write into JSON format

 

If that does not work, a solution is to custom develop a custom JSON destination provider.

 

Best Regards,

Nuno Aguiar

 

You must be logged in to post in the forum