python - HTTP POST from Apps Script to Google Cloud Run Function - Stack Overflow

admin管理员组

文章数量:1345031

I'm quite a beginner in Google Cloud Platform, and I would like to solve the following:

I want to send an HTTP POST request (with JSON data) to a Cloud Run Function using Apps Script, but I don't see any such entry in the Cloud Run Function logs. The Apps Script API is enabled in my GCP project, and I have also provided the GCP project number in the Project settings.

The roles associated with my account: Owner, Cloud Run Source Developer, Service Account User, Service Usage Consumer

The roles associated with the Service Account I specifically created for Cloud Run Functions: Cloud Functions Developer, Cloud Run Admin, Service Account Token Creator, Service Account User

Some info from my code:

appsscript.json:

...
"oauthScopes": [
    ".external_request",
    ";,
    ".container.ui",
    ";,
    "openid"
  ],
...

The request parameters, and the request:

var options = {
    "method": "post",
    "contentType": "application/json",
    "payload": jsonData,
    "headers": {
      "Authorization": "Bearer "+ScriptApp.getIdentityToken() // gcloud auth print-identity-token
    }
};

...

// url: Cloud Run Functions URL
var response = UrlFetchApp.fetch(url, options);

My simple Cloud Run Functions Python code that would handle the request:

import functions_framework

@functions_framework.http
def http_function(request):
    content_type = request.headers["content-type"]
    if content_type == "application/json":
        try:
            request_json = request.get_json(silent=True)
            data = request_json

        except Exception as e:
            return "No JSON data provided", 400

    return f"{data}"

I created a function to test the request (with ScriptApp.getIdentityToken()) and print the response:

HTTP Response Code: 500

HTTP Response Text: 500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

In fact, I also tried using Appscript.GetOAuthToken() as recommended by @TheMaster:

HTTP Response Code: 401, and the HTTP response text is:

Error: Unauthorized … Your client does not have permission to the requested URL

In gcloud shell I tried the following 'CLI test command' that I found in the 'Test service' section:

curl -X POST https://[service URL] -H "Authorization: bearer $(gcloud auth print-identity-token)" -H "Content-Type: application/json" -d '{"name": "Developer"}'

This is the output, so the function itself is working correctly: {"name":"Developer"}

Can someone help me to finally get my function to accept the request?

If I missed sharing any important info, please let me know.

I'm quite a beginner in Google Cloud Platform, and I would like to solve the following:

I want to send an HTTP POST request (with JSON data) to a Cloud Run Function using Apps Script, but I don't see any such entry in the Cloud Run Function logs. The Apps Script API is enabled in my GCP project, and I have also provided the GCP project number in the Project settings.

The roles associated with my account: Owner, Cloud Run Source Developer, Service Account User, Service Usage Consumer

The roles associated with the Service Account I specifically created for Cloud Run Functions: Cloud Functions Developer, Cloud Run Admin, Service Account Token Creator, Service Account User

Some info from my code:

appsscript.json:

...
"oauthScopes": [
    "https://www.googleapis/auth/script.external_request",
    "https://www.googleapis/auth/spreadsheets",
    "https://www.googleapis/auth/script.container.ui",
    "https://www.googleapis/auth/cloud-platform",
    "openid"
  ],
...

The request parameters, and the request:

var options = {
    "method": "post",
    "contentType": "application/json",
    "payload": jsonData,
    "headers": {
      "Authorization": "Bearer "+ScriptApp.getIdentityToken() // gcloud auth print-identity-token
    }
};

...

// url: Cloud Run Functions URL
var response = UrlFetchApp.fetch(url, options);

My simple Cloud Run Functions Python code that would handle the request:

import functions_framework

@functions_framework.http
def http_function(request):
    content_type = request.headers["content-type"]
    if content_type == "application/json":
        try:
            request_json = request.get_json(silent=True)
            data = request_json

        except Exception as e:
            return "No JSON data provided", 400

    return f"{data}"

I created a function to test the request (with ScriptApp.getIdentityToken()) and print the response:

HTTP Response Code: 500

HTTP Response Text: 500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

In fact, I also tried using Appscript.GetOAuthToken() as recommended by @TheMaster:

HTTP Response Code: 401, and the HTTP response text is:

Error: Unauthorized … Your client does not have permission to the requested URL

In gcloud shell I tried the following 'CLI test command' that I found in the 'Test service' section:

curl -X POST https://[service URL] -H "Authorization: bearer $(gcloud auth print-identity-token)" -H "Content-Type: application/json" -d '{"name": "Developer"}'

This is the output, so the function itself is working correctly: {"name":"Developer"}

Can someone help me to finally get my function to accept the request?

If I missed sharing any important info, please let me know.

• python
• json
• google-apps-script
• google-cloud-platform
• http-status-code-500

Share Improve this question Follow edited 7 hours ago TheMaster 51.1k77 gold badges7171 silver badges9999 bronze badges asked yesterday Szabolcs NemeskóSzabolcs Nemeskó 1122 bronze badges New contributor Szabolcs Nemeskó is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct. 11

• Thanks, I fixed it to "Bearer". I created a function to test the request and print the response. Logs: HTTP Response Code: 500, HTTP Response Text: 500 Internal Server Error: The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application. – Szabolcs Nemeskó Commented yesterday
• Authentication is set up, so it is not accessible publicly via curl. – Szabolcs Nemeskó Commented yesterday
• 1. Edit to provide the deployment config of Cloud run 2. You could send gcloud auth print-identity-token with curl the same way: cloud.google/run/docs/authenticating/developers#curl 3. Also try ScriptApp.getOauthToken() instead of identity token and 4. Set up the same gcp by linking the cloud run gcp on apps script: developers.google/apps-script/guides/… – TheMaster Commented yesterday
• @SzabolcsNemeskó Let us know the request payload and response headers. And check your headers it might not have content-type in the request param. – Rohan Kumar Commented yesterday
• @TheMaster I've included the output of Appscript.GetOAuthToken(), the CLI test command output, and I also provided the GCP project number in the Apps Script Project settings. Which deployment configs should I provide? – Szabolcs Nemeskó Commented 8 hours ago

 |  Show 6 more comments

1 Answer 1

Sorted by: Reset to default 0

By default, Apps Script creates a hidden GCP project that operates in the background. Therefore, if you want Apps Script to interact with other GCP services (Cloud Run Function), you need to move the Apps Script execution to your target GCP project.

Guillaume blaquiere's Medium article provides a guide on how to call Google Cloud Run from Apps Script. While I have not tested it myself, I’ve observed that many people have resolved similar concerns using the article. Although the article focuses on Cloud Run, it shares the same infrastructure as Cloud Functions. It might work for you as well.

本文标签： pythonHTTP POST from Apps Script to Google Cloud Run FunctionStack Overflow