I have access to ServiceNow’s REST API, which pulls daily data in JSON format.
I want to use a Google Cloud Platform (GCP) product that downloads the data once a week or every day and stores it there. The data needs to be wrangled after that, possibly in another GCP product.
My inquiries:
- What GCP product should I use to extract data from ServiceNow?
- How do I proceed? Do I have to code it, or can I just use Dataflow?
Which GCP product should I choose to manage and store the data?
I appreciate the support.