I am new to Zapier.
for a customer we need to setup a webserver where they can push data in JSON format via a their own push api.
From there, i would like to be able to fetch the data using Alteryx, in order to place the data on our own SFTP server as a csv.
From there, our secured data-warehouse will pick the file up and add it to our database platform.
Reason for the indirect connection is because we do not allow direct connections to our database environment for security purposes.
I would like to know the following:
- What Zapier licence do I need for this
- What do I need to set this up
- Can data be stored on a European based web-server (because of the patriot act which is a problem for my client
Help is greatly appreciated :-)