Trying to connect "blackbox" external API database to WIX internal Data Collection.

Ask the community
,
1

Hello Fellow Creators,

I am trying to link my “blackbox” API to my WIX Collection to update/populate the data fields so that users can search for available staff to fill shifts or hire as a contractor under their own ABN. as well as adding a “shopping cart” so we can update staff availability as they are hired, let back into the open market or decide to remove themselves from availability. this needs to be a two way street so that as the WIX data collection is updated so will the “blackbox”. The way the API is designed (for security reasons) does not have a central “table” with all the information rather a collection of “tables” that are parsed to create a version of JSON. I have tested if I can even “get” the JSON and read it in the console, yes I can get the JSON and see it in console. however every attempt to then post from the JSON to the internal WIX data collection is met with either an error or nothing at all.

if anyone has any ideas on how to best rectify the situation I would be most appreciative.

Thank you in advance.

2

So assuming that you have seen about using Wix Fetch or Wix HTTP Functions to expose your site to your own API?
https://www.wix.com/corvid/reference/wix-fetch.html
https://support.wix.com/en/article/corvid-accessing-third-party-services-with-the-fetch-api
https://support.wix.com/en/article/corvid-web-modules-calling-server-side-code-from-the-front-end

https://www.wix.com/corvid/reference/wix-http-functions.html
https://support.wix.com/en/article/corvid-exposing-a-site-api-with-http-functions

Corvid Expose Site example.
https://www.wix.com/corvid/forum/corvid-tips-and-updates/example-myapi-and-myapiclient

Also, have you looked at adding a external database through Wix?
https://support.wix.com/en/article/corvid-working-with-external-database-collections
https://support.wix.com/en/article/corvid-adding-and-deleting-an-external-database-collection

3

Hello Ninja,

Thank you for your advice and the links, yes I have tried all the tricks and structures from the linked pages to try and complete the task, I am still running into the same issues were either it trows up an error and cannot complete the fetch/get or fetch/post portion of the code an thus fail or it executes and does nothing other than show in the console that it can read a JSON.

Again thank you.