Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Why is fetch not working propely using Google Apps Script?

I’ve been trying to modify an item related value using a store’s API and although it returns success, the raw object is not bring the values correctly and I can’t find out why.

The Script Editor logs show:
Raw data: {"tipo":3,"quantidade":10} …which is correct.

The response I get is: "code":"010","message":"success","responseCode":200,

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

The destination log shows:
{"erp_id":"","peso":"","gtin":"","ativo":"","tipo":"","quantidade":"", …where tipo and quantidade are empty – thus, incorrect.

Here’s the piece of code I’m working on:

function addToStock() {
  try {
    const ss = SpreadsheetApp.getActiveSpreadsheet();
    const sheet = ss.getSheetByName('Estoque PA');
    const id = sheet.getRange(2, 3).getValue();
    let quantidade = sheet.getRange(2, 5).getValue();
    const variacao = sheet.getRange(2, 6).getValue();

    const raw = JSON.stringify({
      'tipo': 3,
      'quantidade': quantidade
    });
    const headers = {
      'Content-Type': 'application/json',
      'Authorization': "Bearer " + API_KEY
    };

    const requestOptions = {
      "method": 'PUT',
      "headers": headers,
      "body": raw,
      "redirect": 'follow'
    };

    Logger.log('Raw data: ' + raw)

    const url = `https://api.wwwww.com.br/v1/product/stock/${id}/${variacao}`;
    Logger.log('URL: ' + url)
    const response = UrlFetchApp.fetch(url, requestOptions);
    const getText = response.getContentText();
    Logger.log('GetText: ' + getText);

  } catch (err) {
    Logger.log('Error: ' + err)
  }
}

Any idea as to why raw data is not going through all the way?

Thank you!

>Solution :

In the UrlFetchApp options, the request body is indicated by payload rather than body:

const requestOptions = {
  "method": 'PUT',
  "headers": headers,
  "payload": raw, // change this line
  'followRedirects': true // and this one
};

Reference: https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app#fetch(String,Object)

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading