fetch bigquery data and insert to salesforce

Question

I want to use rest api in salesforce apex class to get table data of bigquery of google cloud platform

can someone provider a solution.

I have worked by my way, but I do not know how to authenticate gcp in apex class

Keiji Otsubo · Accepted Answer

Hi  @hu daofu https://trailblazers.salesforce.com/profileView?u=0053A00000DDQJFQA5  ,   Please check this article.   https://gist.github.com/dhaniksahni/94acd0306b5216b647c94c2cd8af918c

Jailer Waddle · Answer

Authenticating directly to GCP from Apex is tricky since you’d need to handle OAuth 2.0 flows manually and store tokens securely. If you're open to using a middleware, tools like Skyvia ( https://skyvia.com/data-integration/integrate-salesforce-google-bigquery ) can sit between BigQuery and Salesforce and handle auth + data movement without writing custom Apex.

fetch bigquery data and insert to salesforce

Salesforce Developer

相关学习

更多帮助