How to automate Import and Export Collection Data Using the wix-data API?

Ask the community
, ,
1

Hi everyone ,

I’m trying to connect an ERP with wix store, so I just looked at this tutorial , and I saw that it seems possible considering that the ERP export data in CSV format and I have to convert it to JSON and vis versa.

  • My first question is : Is it possible to import and export my data with a delta system? I mean the ERP create an ETA_DELTA column in its product database column wish takes number in : 1 for new product 0 to deleted a product;

  • My second question is : I want to automate the import-export system :
    For exporting data, if a customer buy a product :

  1. trigger : accepted payment

  2. action : send product A quantity = product_A_quantity -1 to the ERP
    I saw that I can Import and export database creating a form and adding a button, but my question is as you saw in my previous issues, does it is possible to automate this stuff with accepted payment trigger for export, and allows import automatically generated by the ERP.

Thanks for reading at my incredible English ;), and I hope you could give me some tips…please

2

Hi Guilhem, how are you?

You got find the solution for your problem?
I arrived here searching in internet for the same doubt.

I need to import data which will be receive from an API (JSON) and put it on database inside Wix, but until now, I don´t find how to do.