Ned to design one api to download file from gcs and upload to sharepoint

Google Cloud Apigee
1

Hi ,

below is the payload that apigee will receive in request :

{
“fileType”: “BUILD_ASSURANCE_REPORT”, // or “DEFAULT”
“gcs”: {
“bucketName”: “gcsdingtrigger”,
“folderPath”: “rw/report”,
“fileNames”: [“BA-REPORT.xslx”]
},
“sharepoint”: {
“site”: “pwa/LIGNetExWorkflow”,
“folderServerRelativeUrl”: “/sites/LIGNetExWorkflow/Shared Documents/General/Build Assurance/Reporting”,
“fileNames”: [“BA-REPORT.xlsx”] //Optional, position wise fileNames will be used for creation of destination file name. If not sent or empty, we will use GCS filename as it is.
}
}

we have to take the same file from gcs tag and upload into the details which is mentioned in sharepoint tag

and the file will be higher size

please help to handle this in Apigee x

2

Hi @supriyokumar274, welcome back!

We’ve seen your question and while we wait for the community to share their tips, I recommend checking out the Apigee Knowledge Hub.

Also, don’t miss our upcoming session on Feb 26: ‘Introducing strofa.io - The New AI-Powered Apigee X & Hybrid Development & Management Tool’ with Denis Kalitviansky | :right_arrow: RSVP here.

Hope to see you there!

3

Hi @supriyokumar274 , you will probably need to add a Cloud Run / Function to handle the data transfer, especially if the data size is above 10 MB. So basically I would pass this payload to a Cloud Run / Function with the correct keys / authorization to download / upload the file, and do the data transfer there. See more info here on using Service Account auth from Apigee to call Cloud Run / Functions: Using Google authentication  |  Apigee  |  Google Cloud Documentation.