Hi, can someone help me to receive this data chart - <a href="https://cex.io/rest-

Can not figure out the =ImportJSONViaPost() parameters about importjson HOT 3 OPEN

bradjasper commented on June 2, 2024

Can not figure out the =ImportJSONViaPost() parameters

from importjson.

Comments (3)

Fenrihr commented on June 2, 2024 1

I couldn't resolve as a formula in a cell.

In order to implement it, I created a gs function that executes ImportJSONViaPost and assigned that function to a drawing.

function BYMA_CEDEARS() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var hoja   = spreadsheet.getSheetByName("cotizacion_byma_api");

  // clean destination sheet
  hoja.clear();

  Browser.msgBox("Comensando actualizacion");

  var res = ImportJSONViaPost(
      "https://open.bymadata.com.ar/vanoms-be-core/rest/api/bymadata/free/cedears",
      '{"excludeZeroPxAndQty":false,"T2":true,"T1":false,"T0":false,"Content-Type":"application/json"}',
      "contentType=application/json",null,'noInherit,rawHeaders,noTruncate'
    )

  var numRows = res.length;
  var numCols = res[0].length

  Logger.log("Se encontraron: "+numCols+" columnas y "+numRows+" tickets");
  
  var data = hoja.getRange(1, 1, numRows, numCols);

  // write values in destination sheet
  data.setValues(res);

  Browser.msgBox("Proceso Finalizado");
}

from importjson.

augur-akm commented on June 2, 2024

3 years later:
Here is the correct formula:
=ImportJSONViaPost("https://cex.io/api/price_stats/ETH/USD", "lastHours=24&maxRespArrSize=100")

from importjson.

Fenrihr commented on June 2, 2024

Almost the same problem here!

URL = https://open.bymadata.com.ar/vanoms-be-core/rest/api/bymadata/free/negociable-obligations
POST body =

{
    "excludeZeroPxAndQty":true,
    "T2":true,
    "T1":false,
    "T0":false,
    "Content-Type":"application/json"
}

I have tried:

ImportJSONViaPost(
"https://open.bymadata.com.ar/vanoms-be-core/rest/api/bymadata/free/negociable-obligations";
"excludeZeroPxAndQty=true&T2=true&T1=false&T0=false&Content-Type='application/json'"
)

but i get the error Exception: Request failed for https://open.bymadata.com.ar returned code 415 (línea 220).

Also i tried:

=ImportJSONViaPost(
"https://open.bymadata.com.ar/vanoms-be-core/rest/api/bymadata/free/negociable-obligations";;
"excludeZeroPxAndQty=true,T2=true,T1=false,T0=false,Content-Type='application/json'"
)

but the script remain on "Loading..."

from importjson.

Recommend Projects