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 |