get
http://{url}{}/api/method/emotive_app.api.sales.listview.get_sales_contract_list_data?page_length=20&start=0&fields=["sales_contract.name", "sales_contract.status", "quotes.type_of_sale", "sales_contract.quote", "quotes.lender", "quotes.sale_price", "sales_contract.vehicle_item","sales_contract.stock_no", "quotes.vin", "quotes.buyer_name", "quotes.co_buyer_1_name", "sales_contract.company", "sales_contract.company_branch", "quotes.sales_person", "quotes.split_sp", "sales_contract.modified"]
API Endpoint: Get Sales Contract List Data
Method
GET
Endpoint
{{url}}/api/method/emotive_app.api.sales.listview.get_sales_contract_list_data
Description
This endpoint retrieves a list of sales contracts along with their associated details. It allows users to specify pagination and the fields they wish to receive in the response.
Query Parameters
-
page_length(integer): The number of records to return per page. Example:20. -
start(integer): The starting index for the records to fetch. Example:0. -
fields(array of strings): A list of specific fields to include in the response. Example fields include:-
sales_contract.name -
sales_contract.status -
quotes.type_of_sale -
sales_contract.quote -
quotes.lender -
quotes.sale_price -
sales_contract.vehicle_item -
sales_contract.stock_no -
quotes.vin -
quotes.buyer_name -
quotes.co_buyer_1_name -
sales_contract.company -
sales_contract.company_branch -
quotes.sales_person -
quotes.split_sp -
sales_contract.modified
-
Expected Response Format
The response will be a JSON object containing:
-
message: An object that includes:-
rowData: An array of objects, each representing a sales contract with the specified fields. -
user_info: An object containing user-related information.
-
Example Response
{
"message": {
"rowData": [
{
"sales_contract.name": "",
"sales_contract.status": "",
"quotes.type_of_sale": "",
"sales_contract.quote": "",
"quotes.lender": "",
"quotes.sale_price": 0,
"sales_contract.vehicle_item": "",
"sales_contract.stock_no": "",
"quotes.vin": "",
"quotes.buyer_name": "",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "",
"sales_contract.company_branch": "",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": ""
}
],
"user_info": {}
}
}
This structure provides a comprehensive view of the sales contracts based on the specified parameters.
Recent Requests
Log in to see full request history
| Time | Status | User Agent | |
|---|---|---|---|
Retrieving recent requests… | |||
Loading…
Request
GET {{url}}/api/method/emotive_app.api.sales.listview.get_sales_contract_list_dataQuery Parameters
- page_length – Number of records to return per page.
- start – Starting index for pagination.
- fields – List of fields to be returned in the response, including Sales Contract and Quote fields.
Example Request
{{url}}/api/method/emotive_app.api.sales.listview.get_sales_contract_list_data?page_length=20&start=0&fields=["sales_contract.name","sales_contract.status","quotes.type_of_sale","sales_contract.quote","quotes.lender","quotes.sale_price","sales_contract.vehicle_item","sales_contract.stock_no","quotes.vin","quotes.buyer_name","quotes.co_buyer_1_name","sales_contract.company","sales_contract.company_branch","quotes.sales_person","quotes.split_sp","sales_contract.modified"]Response
The response contains a list of Sales Contracts under the rowData object along with user metadata.
Example response
{
"message": {
"rowData": [
{
"sales_contract.name": "C-0000000001",
"sales_contract.status": "Active",
"quotes.type_of_sale": "Outside Finance",
"sales_contract.quote": "2024-QTE-03-00007",
"quotes.lender": "Chase Bank",
"quotes.sale_price": 14000.0,
"sales_contract.vehicle_item": "VH0000014 - 2003 Dodge Durango - 1D8HS58N73F574091",
"sales_contract.stock_no": "01-00008",
"quotes.vin": "1D8HS58N73F574091",
"quotes.buyer_name": "Aditya A Lolge Sr.",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2026-01-21 14:20:21.469761"
},
{
"sales_contract.name": "C-0000000002",
"sales_contract.status": "Active",
"quotes.type_of_sale": "In House Finance",
"sales_contract.quote": "2024-QTE-03-00014",
"quotes.lender": "Emotive Auto Sales",
"quotes.sale_price": 1000.0,
"sales_contract.vehicle_item": "VH0000039 - 2006 Nissan Altima - 1N4AL11D66C262492",
"sales_contract.stock_no": "01-00024",
"quotes.vin": "1N4AL11D66C262492",
"quotes.buyer_name": "",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-05-03 10:20:15.590815"
},
{
"sales_contract.name": "C-0000000003",
"sales_contract.status": "Active",
"quotes.type_of_sale": "Cash",
"sales_contract.quote": "2024-QTE-03-00021",
"quotes.lender": null,
"quotes.sale_price": 20000.0,
"sales_contract.vehicle_item": "VH0000014 - 2003 Dodge Durango - 1D8HS58N73F574091",
"sales_contract.stock_no": "01-00008",
"quotes.vin": "1D8HS58N73F574091",
"quotes.buyer_name": "Aditya Lolge",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2025-06-02 11:27:02.557018"
},
{
"sales_contract.name": "C-0000000004",
"sales_contract.status": "Active",
"quotes.type_of_sale": "In House Finance",
"sales_contract.quote": "2024-QTE-03-00032",
"quotes.lender": "Emotive Auto Sales",
"quotes.sale_price": 5000.0,
"sales_contract.vehicle_item": "2012 Nissan Altima-1N4BL2AP9CC142086",
"sales_contract.stock_no": "P03086",
"quotes.vin": "1N4BL2AP9CC142086",
"quotes.buyer_name": "Mr Austin Gilberts Jr. (He/Him)",
"quotes.co_buyer_1_name": "Austin Org",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2026-01-19 16:40:49.971969"
},
{
"sales_contract.name": "C-0000000005",
"sales_contract.status": "Active",
"quotes.type_of_sale": "In House Finance",
"sales_contract.quote": "2024-QTE-03-00035",
"quotes.lender": null,
"quotes.sale_price": 1200.0,
"sales_contract.vehicle_item": "VH0000004 - 2015 Ford Fiesta - 3FADP4CJ2FM117972",
"sales_contract.stock_no": "01-00003",
"quotes.vin": "3FADP4CJ2FM117972",
"quotes.buyer_name": "Mr Austin Steves Sr. (They/Them)",
"quotes.co_buyer_1_name": "Mr Austin Gilberts Sr. (He/Him)",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-29 05:10:16.837570"
},
{
"sales_contract.name": "C-0000000006",
"sales_contract.status": "Active",
"quotes.type_of_sale": "Cash",
"sales_contract.quote": "2024-QTE-03-00038",
"quotes.lender": null,
"quotes.sale_price": 123123.0,
"sales_contract.vehicle_item": "VH0000015 - 2000 Lexus LX 470 - JT6HT00W3Y0115791",
"sales_contract.stock_no": "01-00009",
"quotes.vin": "JT6HT00W3Y0115791",
"quotes.buyer_name": "Mr Austin Gilberts Sr. (He/Him)",
"quotes.co_buyer_1_name": "Allen Dobbins",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-18 11:49:52.841877"
},
{
"sales_contract.name": "C-0000000007",
"sales_contract.status": "Active",
"quotes.type_of_sale": "Outside Finance",
"sales_contract.quote": "2024-QTE-03-00045",
"quotes.lender": null,
"quotes.sale_price": 10000.0,
"sales_contract.vehicle_item": null,
"sales_contract.stock_no": null,
"quotes.vin": null,
"quotes.buyer_name": "",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-18 11:49:52.832448"
},
{
"sales_contract.name": "C-0000000008",
"sales_contract.status": "Active",
"quotes.type_of_sale": "Cash",
"sales_contract.quote": "2024-QTE-03-00047",
"quotes.lender": null,
"quotes.sale_price": 90000.0,
"sales_contract.vehicle_item": null,
"sales_contract.stock_no": null,
"quotes.vin": null,
"quotes.buyer_name": "",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-18 11:49:52.819214"
},
{
"sales_contract.name": "C-0000000009",
"sales_contract.status": "Active",
"quotes.type_of_sale": "In House Finance",
"sales_contract.quote": "2024-QTE-04-00004",
"quotes.lender": null,
"quotes.sale_price": 20000.0,
"sales_contract.vehicle_item": "VH0000036 - 2011 Volkswagen Jetta SportWagen - 3VWPL7AJ3BM659144",
"sales_contract.stock_no": "01-00021",
"quotes.vin": "3VWPL7AJ3BM659144",
"quotes.buyer_name": "Allen Dobbins",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-18 11:49:52.757479"
},
{
"sales_contract.name": "C-0000000010",
"sales_contract.status": "Active",
"quotes.type_of_sale": "Wholesale",
"sales_contract.quote": "2024-QTE-04-00006",
"quotes.lender": null,
"quotes.sale_price": 1000.0,
"sales_contract.vehicle_item": null,
"sales_contract.stock_no": null,
"quotes.vin": null,
"quotes.buyer_name": "Allen Dobbins",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-18 11:49:52.797739"
},
{
"sales_contract.name": "C-0000000011",
"sales_contract.status": "Active",
"quotes.type_of_sale": "Wholesale",
"sales_contract.quote": "2024-QTE-04-00030",
"quotes.lender": null,
"quotes.sale_price": 1000.0,
"sales_contract.vehicle_item": null,
"sales_contract.stock_no": null,
"quotes.vin": null,
"quotes.buyer_name": "Mr Austin Wills Gilberts I (Their)",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-18 11:49:52.771137"
},
{
"sales_contract.name": "C-0000000012",
"sales_contract.status": "Active",
"quotes.type_of_sale": "Outside Finance",
"sales_contract.quote": "2024-QTE-04-00041",
"quotes.lender": "Chase Bank",
"quotes.sale_price": 10000.0,
"sales_contract.vehicle_item": "VH0000045 - 2005 Chrysler 300 - 2C3JA63H45H503902",
"sales_contract.stock_no": "01-00027",
"quotes.vin": "2C3JA63H45H503902",
"quotes.buyer_name": "Austin Gills Jos Jr.",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-18 11:49:52.596012"
},
{
"sales_contract.name": "C-0000000013",
"sales_contract.status": "Active",
"quotes.type_of_sale": "Outside Finance",
"sales_contract.quote": "2024-QTE-03-00012",
"quotes.lender": "HDFC Bank",
"quotes.sale_price": 20000.0,
"sales_contract.vehicle_item": "VH0000025 - 2014 Kia Sorento - 5XYKTCA6XEG496995",
"sales_contract.stock_no": "01-00017",
"quotes.vin": "5XYKTCA6XEG496995",
"quotes.buyer_name": "Mr Austin Steves Sr. (They/Them)",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-25 12:06:15.926937"
},
{
"sales_contract.name": "C-0000000014",
"sales_contract.status": "Contracted",
"quotes.type_of_sale": "Outside Finance",
"sales_contract.quote": "2024-QTE-04-00051",
"quotes.lender": "Chase Bank",
"quotes.sale_price": 24950.0,
"sales_contract.vehicle_item": "VH0000043 - 2015 Cadillac ATS - 1G6AL1R30F0108516",
"sales_contract.stock_no": "01-00026",
"quotes.vin": "1G6AL1R30F0108516",
"quotes.buyer_name": "Mr Allen Dobbins",
"quotes.co_buyer_1_name": "Mr Blaine Morgan",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": "Kelly Clarkson",
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-30 04:42:22.148624"
},
{
"sales_contract.name": "C-0000000015",
"sales_contract.status": "Contracted",
"quotes.type_of_sale": "Cash",
"sales_contract.quote": "2024-QTE-03-00002",
"quotes.lender": "HDFC Bank",
"quotes.sale_price": 2000.0,
"sales_contract.vehicle_item": "VH0000039 - 2006 Nissan Altima - 1N4AL11D66C262492",
"sales_contract.stock_no": "01-00024",
"quotes.vin": "1N4AL11D66C262492",
"quotes.buyer_name": "Austin Gills Jos Jr.",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-05-06 09:23:51.290599"
},
{
"sales_contract.name": "C-0000000017",
"sales_contract.status": "Contracted",
"quotes.type_of_sale": "In House Finance",
"sales_contract.quote": "2024-QTE-04-00059",
"quotes.lender": "Emotive Auto Sales",
"quotes.sale_price": 29999.0,
"sales_contract.vehicle_item": "VH0000101 - 2011 Infiniti G Sedan - JN1CV6AR7BM400618",
"sales_contract.stock_no": "01-00049",
"quotes.vin": "JN1CV6AR7BM400618",
"quotes.buyer_name": "Austin Gills Jos Jr.",
"quotes.co_buyer_1_name": "George Gibbson",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-05-28 10:30:30.034883"
},
{
"sales_contract.name": "C-0000000018",
"sales_contract.status": "Contracted",
"quotes.type_of_sale": "Cash",
"sales_contract.quote": "2024-QTE-04-00063",
"quotes.lender": null,
"quotes.sale_price": 1000.0,
"sales_contract.vehicle_item": "VH0000029 - 2006 Mercury Montego - 1MEFM42146G606878",
"sales_contract.stock_no": "01-00020",
"quotes.vin": "1MEFM42146G606878",
"quotes.buyer_name": "",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-29 01:01:04.799452"
},
{
"sales_contract.name": "C-0000000019",
"sales_contract.status": "Booked",
"quotes.type_of_sale": "Outside Finance",
"sales_contract.quote": "2024-QTE-04-00064",
"quotes.lender": "HDFC Bank",
"quotes.sale_price": 11900.0,
"sales_contract.vehicle_item": "VH0000041 - 2001 Acura NSX - JH4NA21621T260903",
"sales_contract.stock_no": "01-00025",
"quotes.vin": "JH4NA21621T260903",
"quotes.buyer_name": "Aditya Lolge",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2025-04-09 11:02:56.169068"
},
{
"sales_contract.name": "C-0000000020",
"sales_contract.status": "Contracted",
"quotes.type_of_sale": "Cash",
"sales_contract.quote": "2024-QTE-04-00065",
"quotes.lender": null,
"quotes.sale_price": 19292.0,
"sales_contract.vehicle_item": "VH0000004 - 2015 Ford Fiesta - 3FADP4CJ2FM117972",
"sales_contract.stock_no": "01-00003",
"quotes.vin": "3FADP4CJ2FM117972",
"quotes.buyer_name": "",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-04-29 03:04:55.923021"
},
{
"sales_contract.name": "C-0000000021",
"sales_contract.status": "Contracted",
"quotes.type_of_sale": "In House Finance",
"sales_contract.quote": "2024-QTE-04-00067",
"quotes.lender": "Emotive Auto Sales",
"quotes.sale_price": 1000.0,
"sales_contract.vehicle_item": "VH0000130 - 2006 Ford F-350 SD - 1FTWW32Y66EC89720",
"sales_contract.stock_no": "01-00067",
"quotes.vin": "1FTWW32Y66EC89720",
"quotes.buyer_name": "Prof Austin Gills JosWilliam II (He/Him)",
"quotes.co_buyer_1_name": "",
"sales_contract.company": "Emotive Auto Sales Inc.",
"sales_contract.company_branch": "Emotive Auto Sales Inc. - 01",
"quotes.sales_person": null,
"quotes.split_sp": null,
"sales_contract.modified": "2024-05-29 00:44:51.408410"
}
],
"user_info": {}
}
}Response Structure
- message – Wrapper object for the API response.
- rowData – Array of Sales Contract records returned based on the query parameters.
- user_info – Object containing user-related metadata
Sales Contract & Quote Fields (rowData)
Each object inside rowData may contain the following fields depending on the fields parameter passed in the request:
- sales_contract.name – Unique identifier of the Sales Contract.
- sales_contract.status – Current business status of the Sales Contract (Active, Booked, Contracted).
- sales_contract.quote – Linked quotation reference number.
- sales_contract.vehicle_item – Vehicle details associated with the contract.
- sales_contract.stock_no – Stock number assigned to the vehicle.
- sales_contract.company – Company under which the Sales Contract is created.
- sales_contract.company_branch – Branch associated with the Sales Contract.
- sales_contract.modified – Timestamp of the last modification to the Sales Contract.
- quotes.type_of_sale – Type of sale (Cash, In House Finance, Outside Finance, Wholesale).
- quotes.lender – Lender involved in the transaction, if applicable.
- quotes.sale_price – Final sale price of the vehicle.
- quotes.vin – Vehicle Identification Number.
- quotes.buyer_name – Primary buyer’s full name.
- quotes.co_buyer_1_name – Co-buyer’s name, if available.
- quotes.sales_person – Salesperson associated with the sale.
- quotes.split_sp – Indicates whether the sale is split between salespersons.