NAV

Authentication

Get API Key

The command returns JSON structured like this:

{
  "organizationId": "orgId",
  "token": "U2FsdGVkX18klEr8+mEJqPVqnCnPnD71dzzae00dipppmFh6QifC+TkNL9OvgRIL5MCGXybPdDJWhCpVMwPMeymIethWQnkT5Bvm71QWTZLExF5YxNM99jeRz6xHRMfz",
  "status": "success"
}

This endpoint returns a token which can be used to authorise the apis.

HTTP Request

POST https://webapi.fieldproxy.com/v3/zapier/generateApiKey

Headers

Key Description
emailId User Email
password User Password

Sheets

Add a row to sheet

Sample request body:

{
  "sheetId": "customer_feed",
  "tableData": {
    "loan_id": "LID003",
    "customer_name": "Aadil",
    "phone_number": "+917825871706",
    "address": "Little Mount, Saidapet, Chennai",
    "pincode": 600023,
    "location": [
      13.014945639117302,
      80.22348278209208
    ],
    "amount_pending": 25000,
    "scheduled_time_": "05:00:00",
    "scheduled_date": "2022-08-23T18:30:00.000Z",
    "satus": "EMI Pending",
    "assigned_agent": "vikas"
  }
}

Response:

{
  "status": true,
  "message": "succesfully row added"
}

This endpoint adds a row to a sheet.

HTTP Request

POST https://webapi.fieldproxy.com/v3/zapier/sheetsRow

Query Header

Parameter Description
x-api-key apikey

Query Body

Parameter Description
sheetId Id of the sheet where the data has to be added
tableData Row Object

Update Sheet Row

Sample request body:

{
  "sheetId": "customer_feed",
  "rowId": 0, //numberic value | required
  "tableData": {
    "loan_id": "LID003",
    "customer_name": "Aadil",
    "phone_number": "+917825871706",
    "address": "Little Mount, Saidapet, Chennai",
    "pincode": 600023,
    "location": [
      13.014945639117302,
      80.22348278209208
    ],
    "amount_pending": 25000,
    "scheduled_time_": "05:00:00",
    "scheduled_date": "2022-08-23T18:30:00.000Z",
    "satus": "EMI Pending",
    "assigned_agent": "vikas"
  }
}

Response:

{
  "status": true,
  "message": "succesfully row updated"
}

This endpoint adds a row to a sheet.

HTTP Request

POST https://webapi.fieldproxy.com/v3/zapier/updateRows

Query Header

Parameter Description
x-api-key apikey

Query Body

Parameter Description
sheetId Id of the sheet where the data has to be updated
rowId Id of the row where the data has to be updated
tableData Row Object