oute-services-sheet-sdk v0.0.10

This module expose helper functions

• Initialization

  var params = {
    url: @server url
    token: @access token
  }
  var Sheet = require("oute-services-sheet-sdk")
  var sheet_instance = new Sheet(params)

Cache functions

Core functions

• Delete records of sub sheet

  let body = {
    "baseId": "TfK0h-CUD",
    "tableId": "clxbdajqq00m712t30wwychn3",
    "records": [
      {
        "id": 1,
        "status": "inactive"
      }
    ]

  };
  await sheet_instance.deleteRecordsOfSubSheet(body)

• Find records in sub sheet

  let body = {
    "tableId": "clxbdajqq00m712t30wwychn3",
    "baseId": "TfK0h-CUD",
    "should_stringify": false,
    "is_field_required": true,
    "manual_filters": {
      "id": "1718177946935_",
      "condition": "and",
      "childs": [
        {
          "id": "1718177946935",
          "key": "is email sent",
          "field": "is_email_sent_fDk29JRW824t77hNCktxLs",
          "type": "YES_NO",
          "operator": {
            "key": "=",
            "value": "is..."
          },
          "value": {
            "type": "fx",
            "blocks": [
              {
                "type": "PRIMITIVES",
                "value": "Yes"
              }
            ]
          },
          "valueStr": "Yes"
        }
      ]
    }
  };
  await sheet_instance.findRecordsOfSubSheet(body);

• Find One record in sub sheet

  let body = {
    "tableId": "clxbdajqq00m712t30wwychn3",
    "baseId": "TfK0h-CUD",
    "manual_filters": {
      "id": "1718177946935_",
      "condition": "and",
      "childs": [
        {
          "id": "1718177946935",
          "key": "is email sent",
          "field": "is_email_sent_fDk29JRW824t77hNCktxLs",
          "type": "YES_NO",
          "operator": {
            "key": "=",
            "value": "is..."
          },
          "value": {
            "type": "fx",
            "blocks": [
              {
                "type": "PRIMITIVES",
                "value": "Yes"
              }
            ]
          },
          "valueStr": "Yes"
        }
      ]
    }
  };
  await sheet_instance.findOneRecordOfSubSheet(body)

• Get sub sheet by sub sheet id

  let query = { tableId: "clxbdajqq00m712t30wwychn3", is_field_required : true};
  let result = await sheet_instance.getSubSheetById(query);

• Get sub sheets by asset id

  let asset_id = "TfK0h-CUD";
  let result = await sheet_instance.getSubSheetsByAssetId(asset_id);

• Create record in sub sheet

  let body = {
    "tableId": "clxbdajqq00m712t30wwychn3",
    "baseId": "TfK0h-CUD",
    "viewId": "clxbdajsr00m812t3tzgz24d0",
    "fields_info": [
      {
        "field_id": 572,
        "data": "Postman"
      }
    ]
  };
  await sheet_instance.createRecordOfSubSheet(body);

• upsert record in sub sheet

  let body = {
    "tableId": "clxbdajqq00m712t30wwychn3",
    "baseId": "TfK0h-CUD",
    "viewId": "clxbdajsr00m812t3tzgz24d0",
    "rowId": 1,
    "fields_info": [
      {
        "field_id": 572,
        "data": "Hi there vedant"
      }
    ]
  };
  await sheet_instance.upsertRecordOfSubSheet(body);