Apps Script passing parameters to cUrl

Question

I am pretty new to Google Apps Script. I am trying to create a script to pull data from a public API. I need to pass parameters, but can't figure out how to do it in Apps Script

The API documenation indicates that the information can be accessed like this:

curl -H "Content-Type: application/json" -X GET 
--header "X-PW-AccessToken:<TOKEN>" \
--header "X-PW-Application:developer_api" \
--header "X-PW-UserEmail:<USER_EMAIL_ADDRESS>" \
-d '{"name":"My Lead","email":{"email":"[email protected]","category":"work"}}'

I have this function setup in Apps Script:

function myFunction() {
  var url = "https://api.prosperworks.com/developer_api/v1/leads/search";
  var fetchParameters = {};
  fetchParameters.method = "post";
  fetchParameters.contentType = "application/json";
  fetchParameters.headers = {
       "X-PW-AccessToken": <TOKEN>,
       "X-PW-Application": "developer_api",
       "X-PW-UserEmail": <USER_EMAIL_ADDRESS>
  };
  fetchParameters.muteHttpExceptions = true;
  fetchParameters.payload = {"name":"My Lead","email":{"email":"[email protected]","category":"work"}};

  var response = UrlFetchApp.fetch(url, fetchParameters);
  var dataAll = JSON.parse(response.getContentText());
}

I added fetchParameters.payload because that appeared to be how to pass the values, but I get this error upon parsing the JSON:

Execution failed: SyntaxError: Unexpected token: <

If I comment out fetchParameters.payload it works successfully, but doesn't factor in any parameters (obviously).

I have tried: fetchParameters.d, fetchParameters.data, and many others, but nothing seems to work.

user2639740 · Accepted Answer · 2016-08-14 22:46:01Z

1

The API documentation shows:

-X GET

You code uses:

fetchParameters.method = "post";

Try changing it to

fetchParameters.method = "get";

answered Aug 14, 2016 at 22:46

user2639740

1,21512 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Apps Script passing parameters to cUrl

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related