A project contract rate table provides markup and pricing information to be used for generating Project Generated Invoices. Every rate table can have lines for each transaction type that identify the criteria to use when applying markup and pricing for that transaction type. The transaction types include timesheets, purchase orders, accounts payable, general ledger, credit cards, and employee expenses.
Returns up to 100 object references from the collection with a key, ID, and link for each rate table. This operation is mostly for use in testing; use query to find objects that meet certain criteria and to specify properties that are returned.
OK
Bad Request
{- "ia::result": [
- {
- "key": "84",
- "id": "RT-00001",
- "href": "/objects/construction/rate-table/84"
}, - {
- "key": "85",
- "id": "RT-00002",
- "href": "/objects/construction/rate-table/85"
}, - {
- "key": "60",
- "id": "RT-00003",
- "href": "/objects/construction/rate-table/60"
}, - {
- "key": "78",
- "id": "RT-00004",
- "href": "/objects/construction/rate-table/78"
}, - {
- "key": "79",
- "id": "RT-00005",
- "href": "/objects/construction/rate-table/79"
}
], - "ia::meta": {
- "totalCount": 5,
- "start": 1,
- "pageSize": 100,
- "next": null,
- "previous": null
}
}
Creates a new rate table.
Rate table to be created
id required | string <= 20 characters Rate table ID Example: "2021-LV2" | ||||||||||||||||||||||||||||
name required | string <= 200 characters Rate table name. Example: "2021 Level 2" | ||||||||||||||||||||||||||||
description | string <= 1000 characters Description of the rate table. Example: "2021 Level 2 Rate Table" | ||||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||
status | string Default: "active" Object status. Active objects are fully functional. Inactive objects are essentially hidden and cannot be used or referenced. Example: "active" | ||||||||||||||||||||||||||||
Array of objects Timesheet lines for the rate table. | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table purchase order lines | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table accounts payable lines | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table general ledger lines | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table credit card lines | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table employee expense lines | |||||||||||||||||||||||||||||
Array
|
Created
Bad Request
{- "id": "2021-LV2",
- "name": "2021 Level 2",
- "description": "2021 Level 2 Rate Table",
- "location": {
- "key": "1"
}, - "status": "active",
- "timesheetLines": {
- "lineNumber": 1,
- "description": "Aug Costing Kit",
- "startDate": "2021-08-03",
- "markupPercent": "8.250",
- "laborRate": "115.500",
- "accumulationType": {
- "key": "2"
}, - "standardCostType": {
- "key": "33"
}, - "standardTask": {
- "key": "3"
}, - "employeePosition": {
- "key": "2"
}, - "laborClass": {
- "key": "2"
}, - "laborShift": {
- "key": "2"
}, - "laborUnion": {
- "key": "2"
}, - "timeType": {
- "key": "1"
}, - "dimensions": {
- "employee": {
- "key": "10"
}, - "project": {
- "key": "2"
}, - "customer": {
- "key": "13"
}, - "vendor": {
- "key": "357"
}, - "item": {
- "key": "13"
}, - "warehouse": {
- "key": "6"
}, - "class": {
- "key": "731"
}, - "task": {
- "key": "2"
}
}
}, - "purchasingLines": {
- "lineNumber": 1,
- "description": "Aug Costing SOPA",
- "startDate": "2021-08-03",
- "markupPercent": "15.900",
- "unitPrice": "112.560",
- "accumulationType": {
- "key": "2"
}, - "standardCostType": {
- "key": "33"
}, - "standardTask": {
- "key": "3"
}, - "dimensions": {
- "employee": {
- "key": "10"
}, - "project": {
- "key": "2"
}, - "customer": {
- "key": "13"
}, - "vendor": {
- "key": "357"
}, - "item": {
- "key": "13"
}, - "warehouse": {
- "key": "6"
}, - "class": {
- "key": "731"
}, - "task": {
- "key": "2"
}
}
}, - "accountsPayableLines": {
- "lineNumber": 1,
- "description": "Aug Service",
- "startDate": "2021-08-01",
- "markupPercent": "25.500",
- "accumulationType": {
- "key": "2"
}, - "standardCostType": {
- "key": "33"
}, - "standardTask": {
- "key": "3"
}, - "dimensions": {
- "employee": {
- "key": "10"
}, - "project": {
- "key": "2"
}, - "customer": {
- "key": "13"
}, - "vendor": {
- "key": "357"
}, - "item": {
- "key": "13"
}, - "warehouse": {
- "key": "6"
}, - "class": {
- "key": "731"
}, - "task": {
- "key": "2"
}
}
}, - "journalLines": {
- "lineNumber": 1,
- "description": "Aug John Smith",
- "startDate": "2021-08-01",
- "markupPercent": "12.500",
- "accumulationType": {
- "key": "2"
}, - "standardCostType": {
- "key": "33"
}, - "standardTask": {
- "key": "3"
}, - "dimensions": {
- "employee": {
- "key": "10"
}, - "project": {
- "key": "2"
}, - "customer": {
- "key": "13"
}, - "vendor": {
- "key": "357"
}, - "item": {
- "key": "13"
}, - "warehouse": {
- "key": "6"
}, - "class": {
- "key": "731"
}, - "task": {
- "key": "2"
}
}
}, - "creditCardLines": {
- "lineNumber": 1,
- "description": "Aug Costing SOPA",
- "startDate": "2021-08-03",
- "markupPercent": "15.900",
- "accumulationType": {
- "key": "2"
}, - "standardCostType": {
- "key": "33"
}, - "standardTask": {
- "key": "3"
}, - "dimensions": {
- "employee": {
- "key": "10"
}, - "project": {
- "key": "2"
}, - "customer": {
- "key": "13"
}, - "vendor": {
- "key": "357"
}, - "item": {
- "key": "13"
}, - "warehouse": {
- "key": "6"
}, - "class": {
- "key": "731"
}, - "task": {
- "key": "2"
}
}
}, - "employeeExpenseLines": {
- "lineNumber": 1,
- "description": "Aug Manager",
- "startDate": "2021-08-02",
- "markupPercent": "14.800",
- "accumulationType": {
- "key": "2"
}, - "standardCostType": {
- "key": "33"
}, - "standardTask": {
- "key": "3"
}, - "dimensions": {
- "employee": {
- "key": "10"
}, - "project": {
- "key": "2"
}, - "customer": {
- "key": "13"
}, - "vendor": {
- "key": "357"
}, - "item": {
- "key": "13"
}, - "warehouse": {
- "key": "6"
}, - "class": {
- "key": "731"
}, - "task": {
- "key": "2"
}
}
}
}
{- "ia::result": {
- "key": "111",
- "href": "/objects/construction/rate-table/111"
}, - "ia::meta": {
- "totalCount": 1
}
}
Returns detailed information for a specified rate table.
key required | string System-assigned key for the rate table. |
OK
Bad Request
{- "ia::result": {
- "key": "145",
- "id": "2021-LV2",
- "name": "2021 Level 2",
- "description": "2021 Level 2 Rate Table",
- "location": {
- "key": "1",
- "id": "1",
- "name": "United States"
}, - "audit": {
- "createdDateTime": "2014-01-08T11:28:12Z",
- "modifiedDateTime": "2014-01-08T11:28:12Z",
- "createdBy": "1",
- "modifiedBy": "95"
}, - "status": "active",
- "timesheetLines": [
- {
- "key": "12",
- "id": "12",
- "rateTable": {
- "key": "145",
- "id": "2021-LV2",
- "name": "2021 Level 2",
- "href": "/objects/construction/rate-table/145"
}, - "href": "/objects/construction/rate-table-timesheet-line/12",
- "lineNumber": 1,
- "description": "Aug Costing Kit",
- "startDate": "2021-08-03",
- "markupPercent": "8.250",
- "laborRate": "115.500",
- "accumulationType": {
- "key": "2",
- "id": "ACCT-2",
- "href": "/objects/construction/accumulation-type/2"
}, - "standardCostType": {
- "key": "33",
- "id": "CT-RT-0010",
- "name": "CT-RT-0010 MATERIAL",
- "href": "/objects/construction/standard-cost-type/33"
}, - "standardTask": {
- "key": "3",
- "id": "TSK-RT-0011",
- "name": "TSK-RT-0011 Name",
- "href": "/objects/construction/standard-task/3"
}, - "employeePosition": {
- "key": "2",
- "id": "COO",
- "name": "Chief Executive Officer",
- "href": "/objects/construction/employee-position/2"
}, - "laborClass": {
- "key": "2",
- "id": "LC-2",
- "name": "Labor class 2",
- "href": "/objects/construction/labor-class/2"
}, - "laborShift": {
- "key": "2",
- "id": "LS-2",
- "name": "Day shift",
- "href": "/objects/construction/labor-shift/2"
}, - "laborUnion": {
- "key": "2",
- "id": "LU-2",
- "name": "Labor union 2",
- "href": "/objects/construction/labor-union/2"
}, - "timeType": {
- "key": "1",
- "id": "Salaries At Root",
- "href": "/objects/projects/time-type/1"
}, - "dimensions": {
- "employee": {
- "key": "10",
- "id": "10",
- "name": "Thomas, Glenn",
- "href": "/objects/company-config/employee/10"
}, - "project": {
- "key": "2",
- "id": "NET-XML30-2",
- "name": "Talcomp training",
- "href": "/objects/projects/project/2"
}, - "customer": {
- "key": "13",
- "id": "113",
- "name": "Jack In the Box",
- "href": "/objects/accounts-receivable/customer/13"
}, - "vendor": {
- "key": "357",
- "id": "1605212096809",
- "name": "GenLab",
- "href": "/objects/accounts-payable/vendor/357"
}, - "item": {
- "key": "13",
- "id": "Case 13",
- "name": "Platform pack",
- "href": "/objects/inventory-control/item/13"
}, - "warehouse": {
- "key": "6",
- "id": "WH01",
- "name": "WH01",
- "href": "/objects/inventory-control/warehouse/6"
}, - "class": {
- "key": "731",
- "id": "REST_CLS_001",
- "name": "Enterprises",
- "href": "/objects/company-config/class/731"
}, - "task": {
- "key": "2",
- "id": "tet",
- "name": "Design",
- "href": "/objects/projects/task/2"
}
}, - "audit": {
- "createdDateTime": "2014-01-08T11:28:12Z",
- "modifiedDateTime": "2014-01-08T11:28:12Z",
- "createdBy": "1",
- "modifiedBy": "95"
}
}
], - "purchasingLines": [
- {
- "key": "176",
- "id": "176",
- "rateTable": {
- "key": "145",
- "id": "2021-LV2",
- "name": "2021 Level 2",
- "href": "/objects/construction/rate-table/145"
}, - "href": "/objects/construction/rate-table-purchasing-line/176",
- "lineNumber": 1,
- "description": "Aug Costing SOPA",
- "startDate": "2021-08-03",
- "markupPercent": "15.900",
- "unitPrice": "112.560",
- "accumulationType": {
- "key": "2",
- "id": "ACCT-2",
- "href": "/objects/construction/accumulation-type/2"
}, - "standardCostType": {
- "key": "33",
- "id": "CT-RT-0010",
- "name": "CT-RT-0010 MATERIAL",
- "href": "/objects/construction/standard-cost-type/33"
}, - "standardTask": {
- "key": "3",
- "id": "TSK-RT-0011",
- "name": "TSK-RT-0011 Name",
- "href": "/objects/construction/standard-task/3"
}, - "dimensions": {
- "employee": {
- "key": "10",
- "id": "10",
- "name": "Thomas, Glenn",
- "href": "/objects/company-config/employee/10"
}, - "project": {
- "key": "2",
- "id": "NET-XML30-2",
- "name": "Talcomp training",
- "href": "/objects/projects/project/2"
}, - "customer": {
- "key": "13",
- "id": "113",
- "name": "Jack In the Box",
- "href": "/objects/accounts-receivable/customer/13"
}, - "vendor": {
- "key": "357",
- "id": "1605212096809",
- "name": "GenLab",
- "href": "/objects/accounts-payable/vendor/357"
}, - "item": {
- "key": "13",
- "id": "Case 13",
- "name": "Platform pack",
- "href": "/objects/inventory-control/item/13"
}, - "warehouse": {
- "key": "6",
- "id": "WH01",
- "name": "WH01",
- "href": "/objects/inventory-control/warehouse/6"
}, - "class": {
- "key": "731",
- "id": "REST_CLS_001",
- "name": "Enterprises",
- "href": "/objects/company-config/class/731"
}, - "task": {
- "key": "2",
- "id": "tet",
- "name": "Design",
- "href": "/objects/projects/task/2"
}
}, - "audit": {
- "createdDateTime": "2014-01-08T11:28:12Z",
- "modifiedDateTime": "2014-01-08T11:28:12Z",
- "createdBy": "1",
- "modifiedBy": "95"
}
}
], - "accountsPayableLines": [
- {
- "key": "397",
- "id": "397",
- "rateTable": {
- "key": "145",
- "id": "2021-LV2",
- "name": "2021 Level 2",
- "href": "/objects/construction/rate-table/145"
}, - "href": "/objects/construction/rate-table-credit-card-line/397",
- "lineNumber": 1,
- "description": "Aug Service",
- "startDate": "2021-08-01",
- "markupPercent": "25.500",
- "accumulationType": {
- "key": "2",
- "id": "ACCT-2",
- "href": "/objects/construction/accumulation-type/2"
}, - "standardCostType": {
- "key": "33",
- "id": "CT-RT-0010",
- "name": "CT-RT-0010 MATERIAL",
- "href": "/objects/construction/standard-cost-type/33"
}, - "standardTask": {
- "key": "3",
- "id": "TSK-RT-0011",
- "name": "TSK-RT-0011 Name",
- "href": "/objects/construction/standard-task/3"
}, - "dimensions": {
- "employee": {
- "key": "10",
- "id": "10",
- "name": "Thomas, Glenn",
- "href": "/objects/company-config/employee/10"
}, - "project": {
- "key": "2",
- "id": "NET-XML30-2",
- "name": "Talcomp training",
- "href": "/objects/projects/project/2"
}, - "customer": {
- "key": "13",
- "id": "113",
- "name": "Jack In the Box",
- "href": "/objects/accounts-receivable/customer/13"
}, - "vendor": {
- "key": "357",
- "id": "1605212096809",
- "name": "GenLab",
- "href": "/objects/accounts-payable/vendor/357"
}, - "item": {
- "key": "13",
- "id": "Case 13",
- "name": "Platform pack",
- "href": "/objects/inventory-control/item/13"
}, - "warehouse": {
- "key": "6",
- "id": "WH01",
- "name": "WH01",
- "href": "/objects/inventory-control/warehouse/6"
}, - "class": {
- "key": "731",
- "id": "REST_CLS_001",
- "name": "Enterprises",
- "href": "/objects/company-config/class/731"
}, - "task": {
- "key": "2",
- "id": "tet",
- "name": "Design",
- "href": "/objects/projects/task/2"
}
}, - "audit": {
- "createdDateTime": "2014-01-08T11:28:12Z",
- "modifiedDateTime": "2014-01-08T11:28:12Z",
- "createdBy": "1",
- "modifiedBy": "95"
}
}
], - "journalLines": [
- {
- "key": "64",
- "id": "64",
- "rateTable": {
- "key": "145",
- "id": "2021-LV2",
- "name": "2021 Level 2",
- "href": "/objects/construction/rate-table/145"
}, - "href": "/objects/construction/rate-table-journal-line/64",
- "lineNumber": 1,
- "description": "Aug John Smith",
- "startDate": "2021-08-01",
- "markupPercent": "12.500",
- "accumulationType": {
- "key": "2",
- "id": "ACCT-2",
- "href": "/objects/construction/accumulation-type/2"
}, - "standardCostType": {
- "key": "33",
- "id": "CT-RT-0010",
- "name": "CT-RT-0010 MATERIAL",
- "href": "/objects/construction/standard-cost-type/33"
}, - "standardTask": {
- "key": "3",
- "id": "TSK-RT-0011",
- "name": "TSK-RT-0011 Name",
- "href": "/objects/construction/standard-task/3"
}, - "dimensions": {
- "employee": {
- "key": "10",
- "id": "10",
- "name": "Thomas, Glenn",
- "href": "/objects/company-config/employee/10"
}, - "project": {
- "key": "2",
- "id": "NET-XML30-2",
- "name": "Talcomp training",
- "href": "/objects/projects/project/2"
}, - "customer": {
- "key": "13",
- "id": "113",
- "name": "Jack In the Box",
- "href": "/objects/accounts-receivable/customer/13"
}, - "vendor": {
- "key": "357",
- "id": "1605212096809",
- "name": "GenLab",
- "href": "/objects/accounts-payable/vendor/357"
}, - "item": {
- "key": "13",
- "id": "Case 13",
- "name": "Platform pack",
- "href": "/objects/inventory-control/item/13"
}, - "warehouse": {
- "key": "6",
- "id": "WH01",
- "name": "WH01",
- "href": "/objects/inventory-control/warehouse/6"
}, - "class": {
- "key": "731",
- "id": "REST_CLS_001",
- "name": "Enterprises",
- "href": "/objects/company-config/class/731"
}, - "task": {
- "key": "2",
- "id": "tet",
- "name": "Design",
- "href": "/objects/projects/task/2"
}
}, - "audit": {
- "createdDateTime": "2014-01-08T11:28:12Z",
- "modifiedDateTime": "2014-01-08T11:28:12Z",
- "createdBy": "1",
- "modifiedBy": "95"
}
}
], - "creditCardLines": [
- {
- "key": "145",
- "id": "145",
- "rateTable": {
- "key": "145",
- "id": "2021-LV2",
- "name": "2021 Level 2",
- "href": "/objects/construction/rate-table/145"
}, - "href": "/objects/construction/rate-table-credit-card-line/145",
- "lineNumber": 1,
- "description": "Aug Costing SOPA",
- "startDate": "2021-08-03",
- "markupPercent": "15.900",
- "accumulationType": {
- "key": "2",
- "id": "ACCT-2",
- "href": "/objects/construction/accumulation-type/2"
}, - "standardCostType": {
- "key": "33",
- "id": "CT-RT-0010",
- "name": "CT-RT-0010 MATERIAL",
- "href": "/objects/construction/standard-cost-type/33"
}, - "standardTask": {
- "key": "3",
- "id": "TSK-RT-0011",
- "name": "TSK-RT-0011 Name",
- "href": "/objects/construction/standard-task/3"
}, - "dimensions": {
- "employee": {
- "key": "10",
- "id": "10",
- "name": "Thomas, Glenn",
- "href": "/objects/company-config/employee/10"
}, - "project": {
- "key": "2",
- "id": "NET-XML30-2",
- "name": "Talcomp training",
- "href": "/objects/projects/project/2"
}, - "customer": {
- "key": "13",
- "id": "113",
- "name": "Jack In the Box",
- "href": "/objects/accounts-receivable/customer/13"
}, - "vendor": {
- "key": "357",
- "id": "1605212096809",
- "name": "GenLab",
- "href": "/objects/accounts-payable/vendor/357"
}, - "item": {
- "key": "13",
- "id": "Case 13",
- "name": "Platform pack",
- "href": "/objects/inventory-control/item/13"
}, - "warehouse": {
- "key": "6",
- "id": "WH01",
- "name": "WH01",
- "href": "/objects/inventory-control/warehouse/6"
}, - "class": {
- "key": "731",
- "id": "REST_CLS_001",
- "name": "Enterprises",
- "href": "/objects/company-config/class/731"
}, - "task": {
- "key": "2",
- "id": "tet",
- "name": "Design",
- "href": "/objects/projects/task/2"
}
}, - "audit": {
- "createdDateTime": "2014-01-08T11:28:12Z",
- "modifiedDateTime": "2014-01-08T11:28:12Z",
- "createdBy": "1",
- "modifiedBy": "95"
}
}
], - "employeeExpenseLines": [
- {
- "key": "30",
- "id": "30",
- "rateTable": {
- "key": "145",
- "id": "2021-LV2",
- "name": "2021 Level 2",
- "href": "/objects/construction/rate-table/145"
}, - "href": "/objects/construction/rate-table-employee-expense-line/30",
- "lineNumber": 1,
- "description": "Aug Manager",
- "startDate": "2021-08-02",
- "markupPercent": "14.800",
- "accumulationType": {
- "key": "2",
- "id": "ACCT-2",
- "href": "/objects/construction/accumulation-type/2"
}, - "standardCostType": {
- "key": "33",
- "id": "CT-RT-0010",
- "name": "CT-RT-0010 MATERIAL",
- "href": "/objects/construction/standard-cost-type/33"
}, - "standardTask": {
- "key": "3",
- "id": "TSK-RT-0011",
- "name": "TSK-RT-0011 Name",
- "href": "/objects/construction/standard-task/3"
}, - "dimensions": {
- "employee": {
- "key": "10",
- "id": "10",
- "name": "Thomas, Glenn",
- "href": "/objects/company-config/employee/10"
}, - "project": {
- "key": "2",
- "id": "NET-XML30-2",
- "name": "Talcomp training",
- "href": "/objects/projects/project/2"
}, - "customer": {
- "key": "13",
- "id": "113",
- "name": "Jack In the Box",
- "href": "/objects/accounts-receivable/customer/13"
}, - "vendor": {
- "key": "357",
- "id": "1605212096809",
- "name": "GenLab",
- "href": "/objects/accounts-payable/vendor/357"
}, - "item": {
- "key": "13",
- "id": "Case 13",
- "name": "Platform pack",
- "href": "/objects/inventory-control/item/13"
}, - "warehouse": {
- "key": "6",
- "id": "WH01",
- "name": "WH01",
- "href": "/objects/inventory-control/warehouse/6"
}, - "class": {
- "key": "731",
- "id": "REST_CLS_001",
- "name": "Enterprises",
- "href": "/objects/company-config/class/731"
}, - "task": {
- "key": "2",
- "id": "tet",
- "name": "Design",
- "href": "/objects/projects/task/2"
}
}, - "audit": {
- "createdDateTime": "2014-01-08T11:28:12Z",
- "modifiedDateTime": "2014-01-08T11:28:12Z",
- "createdBy": "1",
- "modifiedBy": "95"
}
}
]
}, - "ia::meta": {
- "totalCount": 1
}
}
Updates an existing rate table by setting field values. Any fields not provided remain unchanged.
key required | string System-assigned key for the rate table. |
name | string <= 200 characters Rate table name. Example: "2021 Level 2" | ||||||||||||||||||||||||||||
description | string <= 1000 characters Description of the rate table. Example: "2021 Level 2 Rate Table" | ||||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||
status | string Default: "active" Object status. Active objects are fully functional. Inactive objects are essentially hidden and cannot be used or referenced. Example: "active" | ||||||||||||||||||||||||||||
Array of objects Timesheet lines for the rate table. | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table purchase order lines | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table accounts payable lines | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table general ledger lines | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table credit card lines | |||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||
Array of objects Rate table employee expense lines | |||||||||||||||||||||||||||||
Array
|
OK
Bad Request
{- "key": "145",
- "description": "2021 Level 2 Rate Table (Aug)",
- "timesheetLines": [
- {
- "key": "12",
- "lineNumber": 2,
- "description": "Aug Costing Kit (Aug)"
}
]
}
{- "ia::result": {
- "key": "12",
- "id": "2021-LV2",
- "href": "/objects/construction/rate-table/12"
}, - "ia::meta": {
- "totalCount": 1
}
}
Queries an object for filtered data.
object | string Object type to query, in the form Example: "construction/rate-table" | ||||||||
fields | Array of strings List of fields to include in the response. Can be any combination of these:
Example: ["key","id","max:vendor.creditLimit"] | ||||||||
Array of equal (object) or not equal (object) or less than (object) or (less than or equal (object)) or greater than (object) or (greater than or equal (object)) or in (object) or not in (object) or between (object) or not between (object) or contains (object) or does not contain (object) or starts with (object) or does not start with (object) or ends with (object) or does not end with (object) Filter conditions to select the objects to return based on their field values. You use operators and conditions to build your filter, such as Example: [{"$eq":{"status":"active"}},{"$gt":{"totalDue":"1000"}},{"$contains":{"name":"Acme"}}] | |||||||||
Array Any of: Field value must be equal to this specified value. For date fields, you can use these macro values that are relative to the current date or the
These are most useful for queries that you want to save and use repeatedly, such as for views or reports. Just change the For example,
| |||||||||
filterExpression | string Default: "and" Logical operators to apply when there are multiple filter conditions. The conditions in the Shortcuts:
Example: "(1 and 2) or 3" | ||||||||
| |||||||||
Array of objects Set the order of the results by specifying field names to sort by and whether they should be in ascending or descending order. Example: [{"totalDue":"asc"},{"lastPaymentMadeDate":"desc"}] | |||||||||
Array
| |||||||||
start | integer First record of the result set to include in the response. Example: 1 | ||||||||
size | integer Number of records to include in the response. Example: 100 |
OK
Bad Request
{- "object": "accounts-payable/vendor",
- "fields": [
- "id",
- "name",
- "status",
- "href"
], - "filters": [
- {
- "$eq": {
- "status": "active"
}
}, - {
- "$eq": {
- "billingType": "openItem"
}
}
], - "filterExpression": "1 and 2",
- "orderBy": [
- {
- "id": "asc"
}
]
}
{- "ia::result": [
- {
- "id": "Vend-00002",
- "name": "Test vendor",
- "status": "active",
- "href": "/objects/accounts-payable/vendor/85"
}, - {
- "id": "VEND-00010",
- "name": "Design Works",
- "status": "active",
- "href": "/objects/accounts-payable/vendor/111"
}
], - "ia::meta": {
- "totalCount": 2,
- "start": 1,
- "pageSize": 100,
- "next": null,
- "previous": null
}
}