Connecting data from a REST API

[cwalker7]

I am trying to figure out what is the easiest way to connect our CRM's REST API. The CRM we use in Inline Data Systems and I have a API's set up that I can access with a posting token and user ID. I have been able to connect it Google Sheets via Apipheny.io, but have no clue where I would go to do this in GCP. I just want to create a BigQuery Table so I can connect it to Tableau, unless there is a better option. The data in the REST API is JSON formatted. I am stumped and need some guidance! Feel free to over explain things to me, because I have no clue what to do.

[kolban]

Howdy ... I'd suggest drawing a diagram that illustrates what you desire.  For example ... you say that your CRM has a REST API ... is this an API that is called by an external application to request data FROM your CRM or is it an API that your CRM calls when data changes (a webhook)?  Sadly I don't have any skills/knowledge about "Inline CRM".  What is the high level goal you are wanting to achieve?  I sense/guess that it may be to bring your CRM data into BigQuery so that it can be reported upon?  I think it would be useful to hear back from you on this goal.  For example, if my guess is right that you want to bring data out of the CRM and into BigQuery, questions arise such as:

• What is your acceptable latency?
• How much data are we talking about?
• Does the CRM have a data export capability and, if yes, what does it look like?

[cwalker7]

Hi Kolban, as of right now, I am using the Apipheny - API Connector in Google Sheets. I am doing a POST Request and just pasting the address of the "API URL Path". The Content Type is "application/json" and I have this Requests scheduled to perform every hour. I am not sure about the acceptable latency, since it's a scheduled requests, but there are 58,000 totals rows and 14 columns as of right now in my Google Sheet. The CRM can also export data via SFTP, but the developers have told me using their API is my best option.