Get Sales Contract List

This API returns a paginated list of Sales Contracts for list view screens. It supports query parameters to control pagination and dynamically select fields from Sales Contract and related Quote records.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

Request

GET {{url}}/api/method/emotive_app.api.sales.listview.get_sales_contract_list_data

Query 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.
Query Params
integer
Defaults to 20

By default, 20 records are loaded.

integer

Skip the first 'n'

string
Response

Language
Credentials
Header
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json