Report

WIP: A summary needs to be written for Report


GET/v3/report/payment

Payments report

All Payments report

Query String parameters

  • Name
    ids
    Type
    array
    Description
  • Name
    limit
    Type
    number
    Description
    the limit on the number of records to return
  • Name
    orderby
    Type
    string
    Description
    the order instructions for the result
  • Name
    params
    Type
    string
    Description
    additional request specific params
  • Name
    skip
    Type
    number
    Description
    the number of records to skip for a paginated result
  • Name
    where
    Type
    one of: any, any
    Description
    an object to use for filtering the results
  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    array Required
    Description
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    meta
    Type
    object
    Description
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Properties for meta object

  • Name
    hasMore
    Type
    boolean
    Description
    if there are more records available
  • Name
    lastRefreshedAt
    Type
    string
    Description
    the last refreshed at timestamp
  • Name
    sums
    Type
    one of: any, any
    Description
  • Name
    total
    Type
    number
    Description
    the total number of records

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request

GET
/v3/report/payment
curl https://api.shopmonkey.cloud/v3/report/payment \
  -H "Authorization: Bearer ${SM_TOKEN}"

Example Response
application/json

{
  "success": true,
  "data": [
    {
      "id": "id",
      "orderId": "orderId",
      "recordedDate": null,
      "note": "note",
      "paymentType": "paymentType",
      "amountCents": 1,
      "cardType": null,
      "order": {
        "id": "id",
        "number": 1,
        "name": null,
        "generatedVehicleName": null,
        "totalCostCents": 1,
        "paidCostCents": 1,
        "remainingCostCents": null
      },
      "location": {
        "id": "id",
        "name": "name"
      },
      "payer": {
        "firstName": null,
        "lastName": null,
        "companyName": null,
        "normalizedFirstName": null,
        "normalizedLastName": null
      }
    }
  ]
}

GET/v3/report/payment/transaction

Payment Transactions report

Payment transactions report, for operations paid by card (using the payment provider)

Query String parameters

  • Name
    ids
    Type
    array
    Description
  • Name
    limit
    Type
    number
    Description
    the limit on the number of records to return
  • Name
    orderby
    Type
    string
    Description
    the order instructions for the result
  • Name
    params
    Type
    string
    Description
    additional request specific params
  • Name
    skip
    Type
    number
    Description
    the number of records to skip for a paginated result
  • Name
    where
    Type
    one of: any, any
    Description
    an object to use for filtering the results
  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    array Required
    Description
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    meta
    Type
    object
    Description
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Properties for meta object

  • Name
    hasMore
    Type
    boolean
    Description
    if there are more records available
  • Name
    lastRefreshedAt
    Type
    string
    Description
    the last refreshed at timestamp
  • Name
    sums
    Type
    object
    Description
  • Name
    total
    Type
    number
    Description
    the total number of records
  • Name
    totalAmount
    Type
    number
    Description
  • Name
    totalFee
    Type
    number
    Description
  • Name
    totalNet
    Type
    number
    Description
  • Name
    totalSurcharge
    Type
    number
    Description

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request

GET
/v3/report/payment/transaction
curl https://api.shopmonkey.cloud/v3/report/payment/transaction \
  -H "Authorization: Bearer ${SM_TOKEN}"

Example Response
application/json

{
  "success": true,
  "data": [
    {
      "id": "id",
      "createdDate": "createdDate",
      "paymentMode": "paymentMode",
      "amountCents": 1,
      "cardType": null,
      "cardDigits": null,
      "provider": null,
      "providerFee": null,
      "net": 1,
      "order": {
        "id": "id",
        "number": 1,
        "name": null
      },
      "location": {
        "id": "id",
        "name": "name"
      },
      "payer": {
        "id": "id",
        "firstName": null,
        "lastName": null,
        "normalizedFirstName": null,
        "normalizedLastName": null
      }
    }
  ]
}

GET/v3/report/payment/payout

Payouts report

Payouts from SM Payments to the Shop report

Query String parameters

  • Name
    ids
    Type
    array
    Description
  • Name
    limit
    Type
    number
    Description
    the limit on the number of records to return
  • Name
    orderby
    Type
    string
    Description
    the order instructions for the result
  • Name
    params
    Type
    string
    Description
    additional request specific params
  • Name
    skip
    Type
    number
    Description
    the number of records to skip for a paginated result
  • Name
    where
    Type
    one of: any, any
    Description
    an object to use for filtering the results
  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    array Required
    Description
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    meta
    Type
    object
    Description
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Properties for meta object

  • Name
    hasMore
    Type
    boolean
    Description
    if there are more records available
  • Name
    lastRefreshedAt
    Type
    string
    Description
    the last refreshed at timestamp
  • Name
    sums
    Type
    object
    Description
  • Name
    total
    Type
    number
    Description
    the total number of records
  • Name
    availableCents
    Type
    number
    Description
  • Name
    inTransitCents
    Type
    number
    Description
  • Name
    pendingCents
    Type
    number
    Description
  • Name
    totalAmountCents
    Type
    number
    Description
  • Name
    totalCents
    Type
    number
    Description

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request

GET
/v3/report/payment/payout
curl https://api.shopmonkey.cloud/v3/report/payment/payout \
  -H "Authorization: Bearer ${SM_TOKEN}"

Example Response
application/json

{
  "success": true,
  "data": [
    {
      "id": "id",
      "createdDate": "createdDate",
      "updatedDate": "updatedDate",
      "arrivalDate": null,
      "companyId": "companyId",
      "locationId": "locationId",
      "provider": "provider",
      "amountCents": 1,
      "status": "status",
      "description": null,
      "error": null,
      "location": {
        "id": "id",
        "name": "name"
      }
    }
  ]
}

GET/v3/report/order

All Orders report

All Orders report

Query String parameters

  • Name
    ids
    Type
    array
    Description
  • Name
    limit
    Type
    number
    Description
    the limit on the number of records to return
  • Name
    orderby
    Type
    string
    Description
    the order instructions for the result
  • Name
    params
    Type
    string
    Description
    additional request specific params
  • Name
    skip
    Type
    number
    Description
    the number of records to skip for a paginated result
  • Name
    where
    Type
    one of: any, any
    Description
    an object to use for filtering the results
  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    array Required
    Description
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    meta
    Type
    object
    Description
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Properties for meta object

  • Name
    hasMore
    Type
    boolean
    Description
    if there are more records available
  • Name
    lastRefreshedAt
    Type
    string
    Description
    the last refreshed at timestamp
  • Name
    sums
    Type
    object
    Description
  • Name
    total
    Type
    number
    Description
    the total number of records
  • Name
    epaCents
    Type
    number
    Description
  • Name
    feesCents
    Type
    number
    Description
  • Name
    gstCents
    Type
    number
    Description
  • Name
    hstCents
    Type
    number
    Description
  • Name
    laborCostCents
    Type
    number
    Description
  • Name
    laborRetailCents
    Type
    number
    Description
  • Name
    laborWholesaleCents
    Type
    number
    Description
  • Name
    paidCostCents
    Type
    number
    Description
  • Name
    partsRetailCents
    Type
    number
    Description
  • Name
    partsWholesaleCents
    Type
    number
    Description
  • Name
    pstCents
    Type
    number
    Description
  • Name
    remainingCostCents
    Type
    number
    Description
  • Name
    shopSuppliesCents
    Type
    number
    Description
  • Name
    subcontractsRetailCents
    Type
    number
    Description
  • Name
    subcontractsWholesaleCents
    Type
    number
    Description
  • Name
    taxCents
    Type
    number
    Description
  • Name
    tiresRetailCents
    Type
    number
    Description
  • Name
    tiresWholesaleCents
    Type
    number
    Description
  • Name
    totalCostCents
    Type
    number
    Description
  • Name
    totalDiscountCents
    Type
    number
    Description
  • Name
    totalProfitCents
    Type
    number
    Description
  • Name
    totalRetailCents
    Type
    number
    Description
  • Name
    totalWholesaleCents
    Type
    number
    Description

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request

GET
/v3/report/order
curl https://api.shopmonkey.cloud/v3/report/order \
  -H "Authorization: Bearer ${SM_TOKEN}"

Example Response
application/json

{
  "success": true,
  "data": [
    {
      "id": "id",
      "createdDate": "createdDate",
      "companyId": "companyId",
      "number": 1,
      "name": null,
      "purchaseOrderNumber": null,
      "generatedVehicleName": null,
      "archived": true,
      "authorized": true,
      "invoiced": true,
      "invoicedDate": null,
      "paid": true,
      "totalCostCents": 1,
      "paidCostCents": 1,
      "remainingCostCents": null,
      "partsCents": 1,
      "tiresCents": 1,
      "laborCents": 1,
      "epaCents": 1,
      "shopSuppliesCents": 1,
      "feesCents": 1,
      "taxCents": 1,
      "dueDate": null,
      "completedDate": null,
      "fullyPaidDate": null,
      "customer": {
        "id": "id",
        "firstName": null,
        "lastName": null,
        "companyName": null,
        "normalizedFirstName": null,
        "normalizedLastName": null
      },
      "laborHours": 1,
      "lastPaymentPosted": null,
      "location": {
        "id": "id",
        "name": "name"
      },
      "paymentTypes": [
        "paymentTypes"
      ],
      "paymentTerm": {
        "id": "id",
        "name": "name"
      },
      "serviceWriter": {
        "id": "id",
        "firstName": "firstName",
        "lastName": "lastName"
      },
      "workflowStatus": {
        "id": "id",
        "name": null
      },
      "vehicle": {
        "id": "id",
        "vin": null,
        "unit": null,
        "licensePlate": null,
        "licensePlateState": null,
        "licensePlateCountry": "licensePlateCountry"
      }
    }
  ]
}

GET/v3/report/end_of_day

End Of Day Report

End of Day

Query String parameters

  • Name
    experimental
    Type
    boolean
    Description
  • Name
    where
    Type
    object Required
    Description
  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description

Properties for where object

  • Name
    fullyPaidDate
    Type
    object
    Description
  • Name
    invoicedDate
    Type
    object
    Description
  • Name
    locationId
    Type
    array
    Description
  • Name
    paidStatus
    Type
    one of: paid, unpaid, overdue
    Description
    Paid status
  • Name
    serviceWriterId
    Type
    array
    Description

Properties for fullyPaidDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Properties for invoicedDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message
  • Name
    data
    Type
    object Required
    Description

Properties for data object

  • Name
    lineItems
    Type
    object
    Description
  • Name
    orders
    Type
    object
    Description
  • Name
    payments
    Type
    object
    Description
  • Name
    performance
    Type
    object
    Description
  • Name
    sales
    Type
    object
    Description

Properties for lineItems object

  • Name
    fees
    Type
    object Required
    Description
  • Name
    labors
    Type
    object Required
    Description
  • Name
    parts
    Type
    object Required
    Description
  • Name
    subcontracts
    Type
    object Required
    Description
  • Name
    tires
    Type
    object Required
    Description
  • Name
    totalsSum
    Type
    object Required
    Description

Properties for fees object

  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    subtotal
    Type
    number Required
    Description
  • Name
    totalRetail
    Type
    number Required
    Description

Properties for labors object

  • Name
    discount
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    subtotal
    Type
    number Required
    Description
  • Name
    taxExempt
    Type
    number Required
    Description
  • Name
    taxExemptGST
    Type
    number Required
    Description
  • Name
    taxExemptHST
    Type
    number Required
    Description
  • Name
    taxExemptPST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description
  • Name
    totalCost
    Type
    number Required
    Description
  • Name
    totalProfit
    Type
    number Required
    Description
  • Name
    totalRetail
    Type
    number Required
    Description

Properties for parts object

  • Name
    discount
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    subtotal
    Type
    number Required
    Description
  • Name
    taxExempt
    Type
    number Required
    Description
  • Name
    taxExemptGST
    Type
    number Required
    Description
  • Name
    taxExemptHST
    Type
    number Required
    Description
  • Name
    taxExemptPST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description
  • Name
    totalCost
    Type
    number Required
    Description
  • Name
    totalProfit
    Type
    number Required
    Description
  • Name
    totalRetail
    Type
    number Required
    Description

Properties for subcontracts object

  • Name
    discount
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    subtotal
    Type
    number Required
    Description
  • Name
    taxExempt
    Type
    number Required
    Description
  • Name
    taxExemptGST
    Type
    number Required
    Description
  • Name
    taxExemptHST
    Type
    number Required
    Description
  • Name
    taxExemptPST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description
  • Name
    totalCost
    Type
    number Required
    Description
  • Name
    totalProfit
    Type
    number Required
    Description
  • Name
    totalRetail
    Type
    number Required
    Description

Properties for tires object

  • Name
    discount
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    subtotal
    Type
    number Required
    Description
  • Name
    taxExempt
    Type
    number Required
    Description
  • Name
    taxExemptGST
    Type
    number Required
    Description
  • Name
    taxExemptHST
    Type
    number Required
    Description
  • Name
    taxExemptPST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description
  • Name
    totalCost
    Type
    number Required
    Description
  • Name
    totalProfit
    Type
    number Required
    Description
  • Name
    totalRetail
    Type
    number Required
    Description

Properties for totalsSum object

  • Name
    discount
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    subtotal
    Type
    number Required
    Description
  • Name
    taxExempt
    Type
    number Required
    Description
  • Name
    taxExemptGST
    Type
    number Required
    Description
  • Name
    taxExemptHST
    Type
    number Required
    Description
  • Name
    taxExemptPST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description
  • Name
    totalCost
    Type
    number Required
    Description
  • Name
    totalProfit
    Type
    number Required
    Description
  • Name
    totalRetail
    Type
    number Required
    Description

Properties for orders object

  • Name
    discountTotal
    Type
    number Required
    Description
  • Name
    epaTotal
    Type
    number Required
    Description
  • Name
    feesSubtotal
    Type
    number Required
    Description
  • Name
    gstTotal
    Type
    number Required
    Description
  • Name
    hstTotal
    Type
    number Required
    Description
  • Name
    lineItemsSubtotal
    Type
    number Required
    Description
  • Name
    ordersTotal
    Type
    number Required
    Description
  • Name
    pstTotal
    Type
    number Required
    Description
  • Name
    shopSuppliesTotal
    Type
    number Required
    Description
  • Name
    taxesTotal
    Type
    number Required
    Description

Properties for payments object

  • Name
    Unknown
    Type
    object
    Description
  • Name
    account_receivable
    Type
    object
    Description
  • Name
    ach
    Type
    object
    Description
  • Name
    american express
    Type
    object
    Description
  • Name
    american_express
    Type
    object
    Description
  • Name
    amex
    Type
    object
    Description
  • Name
    card
    Type
    object
    Description
  • Name
    cash
    Type
    object
    Description
  • Name
    check
    Type
    object
    Description
  • Name
    diners
    Type
    object
    Description
  • Name
    discover
    Type
    object
    Description
  • Name
    financing
    Type
    object
    Description
  • Name
    insurance
    Type
    object
    Description
  • Name
    internal
    Type
    object
    Description
  • Name
    jcb
    Type
    object
    Description
  • Name
    mastercard
    Type
    object
    Description
  • Name
    mechanical_installment
    Type
    object
    Description
  • Name
    other
    Type
    object
    Description
  • Name
    otherCards
    Type
    object
    Description
  • Name
    payPal
    Type
    object
    Description
  • Name
    policy
    Type
    object
    Description
  • Name
    reconditioning
    Type
    object
    Description
  • Name
    refunds
    Type
    object
    Description
  • Name
    total
    Type
    object
    Description
  • Name
    unionpay
    Type
    object
    Description
  • Name
    unknown
    Type
    object
    Description
  • Name
    vehicle_service_contract
    Type
    object
    Description
  • Name
    venmo
    Type
    object
    Description
  • Name
    visa
    Type
    object
    Description
  • Name
    warranty
    Type
    object
    Description
  • Name
    zelle
    Type
    object
    Description

Properties for Unknown object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for account_receivable object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for ach object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for american express object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for american_express object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for amex object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for card object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for cash object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for check object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for diners object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for discover object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for financing object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for insurance object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for internal object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for jcb object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for mastercard object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for mechanical_installment object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for other object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for otherCards object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for payPal object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for policy object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for reconditioning object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for refunds object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for total object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for unionpay object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for unknown object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for vehicle_service_contract object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for venmo object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for visa object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for warranty object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for zelle object

  • Name
    amount
    Type
    number Required
    Description
  • Name
    count
    Type
    number Required
    Description
  • Name
    isCardPaymentType
    Type
    boolean
    Description

Properties for performance object

  • Name
    avgOrderProfit
    Type
    number Required
    Description
  • Name
    avgOrderProfitMargin
    Type
    number Required
    Description
  • Name
    avgSales
    Type
    number Required
    Description
  • Name
    effectiveLaborRate
    Type
    number Required
    Description
  • Name
    grossProfit
    Type
    number Required
    Description
  • Name
    grossSales
    Type
    number Required
    Description
  • Name
    totalLaborCost
    Type
    number Required
    Description

Properties for sales object

  • Name
    closeRate
    Type
    number Required
    Description
  • Name
    estimatedHours
    Type
    number Required
    Description
  • Name
    invoicedHours
    Type
    number Required
    Description
  • Name
    paidInvoices
    Type
    number Required
    Description
  • Name
    partialInvoices
    Type
    number Required
    Description
  • Name
    totalEstimates
    Type
    number Required
    Description
  • Name
    totalInvoices
    Type
    number Required
    Description
  • Name
    totalLaborsInvoiced
    Type
    number Required
    Description
  • Name
    totalOrders
    Type
    number Required
    Description

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request

GET
/v3/report/end_of_day
curl https://api.shopmonkey.cloud/v3/report/end_of_day \
  -H "Authorization: Bearer ${SM_TOKEN}"

Example Response
application/json

{
  "success": true,
  "data": {
    "lineItems": {
      "fees": {
        "nonTaxable": 1,
        "subtotal": 1,
        "totalRetail": 1
      },
      "labors": {
        "discount": 1,
        "nonTaxable": 1,
        "subtotal": 1,
        "taxExempt": 1,
        "taxable": 1,
        "totalCost": 1,
        "totalProfit": 1,
        "totalRetail": 1
      },
      "parts": {
        "discount": 1,
        "nonTaxable": 1,
        "subtotal": 1,
        "taxExempt": 1,
        "taxable": 1,
        "totalCost": 1,
        "totalProfit": 1,
        "totalRetail": 1
      },
      "subcontracts": {
        "discount": 1,
        "nonTaxable": 1,
        "subtotal": 1,
        "taxExempt": 1,
        "taxable": 1,
        "totalCost": 1,
        "totalProfit": 1,
        "totalRetail": 1
      },
      "tires": {
        "discount": 1,
        "nonTaxable": 1,
        "subtotal": 1,
        "taxExempt": 1,
        "taxable": 1,
        "totalCost": 1,
        "totalProfit": 1,
        "totalRetail": 1
      },
      "totalsSum": {
        "discount": 1,
        "nonTaxable": 1,
        "subtotal": 1,
        "taxExempt": 1,
        "taxable": 1,
        "totalCost": 1,
        "totalProfit": 1,
        "totalRetail": 1
      }
    },
    "payments": {
      "cash": {
        "amount": 1,
        "count": 1
      },
      "check": {
        "amount": 1,
        "count": 1
      },
      "other": {
        "amount": 1,
        "count": 1
      },
      "visa": {
        "amount": 1,
        "count": 1
      },
      "mastercard": {
        "amount": 1,
        "count": 1
      },
      "amex": {
        "amount": 1,
        "count": 1
      },
      "discover": {
        "amount": 1,
        "count": 1
      },
      "diners": {
        "amount": 1,
        "count": 1
      },
      "jcb": {
        "amount": 1,
        "count": 1
      },
      "unionpay": {
        "amount": 1,
        "count": 1
      },
      "otherCards": {
        "amount": 1,
        "count": 1
      },
      "refunds": {
        "amount": 1,
        "count": 1
      },
      "card": {
        "amount": 1,
        "count": 1
      },
      "cashAndCheck": {
        "amount": 1,
        "count": 1
      },
      "total": {
        "amount": 1,
        "count": 1
      }
    },
    "performance": {
      "avgSales": 1,
      "avgOrderProfit": 1,
      "avgOrderProfitMargin": 1,
      "grossSales": 1,
      "grossProfit": 1,
      "totalLaborCost": 1,
      "effectiveLaborRate": 1
    },
    "orders": {
      "lineItemsSubtotal": 1,
      "ordersTotal": 1,
      "feesSubtotal": 1,
      "discountTotal": 1,
      "epaTotal": 1,
      "shopSuppliesTotal": 1,
      "taxesTotal": 1,
      "gstTotal": 1,
      "pstTotal": 1,
      "hstTotal": 1
    },
    "sales": {
      "totalEstimates": 1,
      "totalInvoices": 1,
      "totalOrders": 1,
      "partialInvoices": 1,
      "paidInvoices": 1,
      "estimatedHours": 1,
      "invoicedHours": 1,
      "closeRate": 1
    }
  }
}

GET/v3/report/sales

Sales Summary Report

Sales Summary

Query String parameters

  • Name
    locationId
    Type
    array
    Description
  • Name
    where
    Type
    object Required
    Description
  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description

Properties for where object

  • Name
    date
    Type
    object
    Description

Properties for date object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message
  • Name
    data
    Type
    object Required
    Description

Properties for data object

  • Name
    allInvoices
    Type
    object
    Description
  • Name
    invoiced
    Type
    object
    Description
  • Name
    lostSales
    Type
    object
    Description
  • Name
    paidInvoices
    Type
    object
    Description
  • Name
    payments
    Type
    object
    Description

Properties for allInvoices object

  • Name
    discountTotal
    Type
    number Required
    Description
  • Name
    epaTotal
    Type
    number Required
    Description
  • Name
    feesSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    gstTotal
    Type
    number Required
    Description
  • Name
    hstTotal
    Type
    number Required
    Description
  • Name
    laborsSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    partsSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    postDiscountSubtotal
    Type
    number Required
    Description
  • Name
    pstTotal
    Type
    number Required
    Description
  • Name
    shopSuppliesTotal
    Type
    number Required
    Description
  • Name
    subcontractsSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    subtotal
    Type
    number Required
    Description
  • Name
    taxesTotal
    Type
    number Required
    Description
  • Name
    tiresSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    total
    Type
    number Required
    Description

Properties for invoiced object

  • Name
    data
    Type
    array Required
    Description
  • Name
    totals
    Type
    object Required
    Description

Properties for totals object

  • Name
    amount
    Type
    number Required
    Description
    Total amount of cost for invoiced orders
  • Name
    avgPartsMargin
    Type
    number Required
    Description
    Average parts margin of invoiced orders
  • Name
    avgRepairOrderCost
    Type
    number Required
    Description
    Average repair cost of invoiced orders

Properties for lostSales object

  • Name
    data
    Type
    array Required
    Description
  • Name
    totals
    Type
    object Required
    Description

Properties for totals object

  • Name
    amount
    Type
    number Required
    Description
    Total amount of deferred cost

Properties for paidInvoices object

  • Name
    discountTotal
    Type
    number Required
    Description
  • Name
    epaTotal
    Type
    number Required
    Description
  • Name
    feesSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    gstTotal
    Type
    number Required
    Description
  • Name
    hstTotal
    Type
    number Required
    Description
  • Name
    laborsSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    partsSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    postDiscountSubtotal
    Type
    number Required
    Description
  • Name
    pstTotal
    Type
    number Required
    Description
  • Name
    shopSuppliesTotal
    Type
    number Required
    Description
  • Name
    subcontractsSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    subtotal
    Type
    number Required
    Description
  • Name
    taxesTotal
    Type
    number Required
    Description
  • Name
    tiresSubtotalWithoutDiscount
    Type
    number Required
    Description
  • Name
    total
    Type
    number Required
    Description

Properties for payments object

  • Name
    data
    Type
    array Required
    Description
  • Name
    totals
    Type
    object Required
    Description

Properties for totals object

  • Name
    amount
    Type
    number Required
    Description
    Total amount of payments
  • Name
    customerCount
    Type
    number Required
    Description
    Total number of unique paying customers

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request

GET
/v3/report/sales
curl https://api.shopmonkey.cloud/v3/report/sales \
  -H "Authorization: Bearer ${SM_TOKEN}"

Example Response
application/json

{
  "success": true,
  "data": {
    "payments": {
      "data": [
        {
          "paidAmountPerDay": 1,
          "paymentDate": "paymentDate",
          "customerIds": [
            "customerIds"
          ]
        }
      ],
      "totals": {
        "amount": 1,
        "customerCount": 1
      }
    },
    "invoiced": {
      "data": [
        {
          "totalCostPerDay": 1,
          "invoicedDate": "invoicedDate",
          "ordersCountPerDay": 1
        }
      ],
      "totals": {
        "amount": 1,
        "avgRepairOrderCost": 1,
        "avgPartsMargin": 1
      }
    },
    "lostSales": {
      "data": [
        {
          "deferredTotalPerDay": 1,
          "invoicedDate": "invoicedDate",
          "ordersCountPerDay": 1
        }
      ],
      "totals": {
        "amount": 1
      }
    },
    "allInvoices": {
      "laborsSubtotalWithoutDiscount": 1,
      "partsSubtotalWithoutDiscount": 1,
      "tiresSubtotalWithoutDiscount": 1,
      "subcontractsSubtotalWithoutDiscount": 1,
      "epaTotal": 1,
      "shopSuppliesTotal": 1,
      "feesSubtotalWithoutDiscount": 1,
      "subtotal": 1,
      "discountTotal": 1,
      "postDiscountSubtotal": 1,
      "taxesTotal": 1,
      "gstTotal": 1,
      "pstTotal": 1,
      "hstTotal": 1,
      "total": 1
    },
    "paidInvoices": {
      "laborsSubtotalWithoutDiscount": 1,
      "partsSubtotalWithoutDiscount": 1,
      "tiresSubtotalWithoutDiscount": 1,
      "subcontractsSubtotalWithoutDiscount": 1,
      "epaTotal": 1,
      "shopSuppliesTotal": 1,
      "feesSubtotalWithoutDiscount": 1,
      "subtotal": 1,
      "discountTotal": 1,
      "postDiscountSubtotal": 1,
      "taxesTotal": 1,
      "gstTotal": 1,
      "pstTotal": 1,
      "hstTotal": 1,
      "total": 1
    }
  }
}

GET/v3/report/customer_aging

Customer Aging report

Customer Aging report

Query String parameters

  • Name
    ids
    Type
    array
    Description
  • Name
    limit
    Type
    number
    Description
    the limit on the number of records to return
  • Name
    orderby
    Type
    string
    Description
    the order instructions for the result
  • Name
    params
    Type
    string
    Description
    additional request specific params
  • Name
    skip
    Type
    number
    Description
    the number of records to skip for a paginated result
  • Name
    where
    Type
    one of: any, any
    Description
    an object to use for filtering the results
  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    array Required
    Description
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    meta
    Type
    object
    Description
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Properties for meta object

  • Name
    hasMore
    Type
    boolean
    Description
    if there are more records available
  • Name
    lastRefreshedAt
    Type
    string
    Description
    the last refreshed at timestamp
  • Name
    sums
    Type
    object
    Description
  • Name
    total
    Type
    number
    Description
    the total number of records
  • Name
    totalCredits
    Type
    number
    Description
  • Name
    totalFrom0to30
    Type
    number
    Description
  • Name
    totalFrom31to60
    Type
    number
    Description
  • Name
    totalFrom61to90
    Type
    number
    Description
  • Name
    totalFrom91orMore
    Type
    number
    Description
  • Name
    totalTotalDue
    Type
    number
    Description

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request

GET
/v3/report/customer_aging
curl https://api.shopmonkey.cloud/v3/report/customer_aging \
  -H "Authorization: Bearer ${SM_TOKEN}"

Example Response
application/json

{
  "success": true,
  "data": [
    {
      "id": "id",
      "firstName": null,
      "lastName": null,
      "companyName": null,
      "normalizedFirstName": null,
      "normalizedLastName": null,
      "credits": 1,
      "from0to30": 1,
      "from31to60": 1,
      "from61to90": 1,
      "from91orMore": 1,
      "totalDue": 1
    }
  ]
}

GET/v3/report/line_item_sales_tax

Sales Tax Report

Line Items Sales Tax Report

Query String parameters

  • Name
    locationId
    Type
    array
    Description
  • Name
    where
    Type
    object Required
    Description
  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description
  • Name
    experimental
    Type
    boolean
    Description

Properties for where object

  • Name
    fullyPaidDate
    Type
    object
    Description
  • Name
    invoicedDate
    Type
    object
    Description
  • Name
    paidStatuses
    Type
    array
    Description

Properties for fullyPaidDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Properties for invoicedDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message
  • Name
    data
    Type
    object Required
    Description

Properties for data object

  • Name
    epa
    Type
    object
    Description
  • Name
    fees
    Type
    object
    Description
  • Name
    gstOwed
    Type
    number
    Description
  • Name
    gstTotal
    Type
    number
    Description
  • Name
    hstOwed
    Type
    number
    Description
  • Name
    hstTotal
    Type
    number
    Description
  • Name
    labors
    Type
    object
    Description
  • Name
    parts
    Type
    object
    Description
  • Name
    pstOwed
    Type
    number
    Description
  • Name
    pstTotal
    Type
    number
    Description
  • Name
    shopSupplies
    Type
    object
    Description
  • Name
    subcontracts
    Type
    object
    Description
  • Name
    taxesOwed
    Type
    number
    Description
  • Name
    taxesTotal
    Type
    number
    Description
  • Name
    tires
    Type
    object
    Description

Properties for epa object

  • Name
    exempt
    Type
    number Required
    Description
  • Name
    exemptGST
    Type
    number Required
    Description
  • Name
    exemptHST
    Type
    number Required
    Description
  • Name
    exemptPST
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description

Properties for fees object

  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description

Properties for labors object

  • Name
    exempt
    Type
    number Required
    Description
  • Name
    exemptGST
    Type
    number Required
    Description
  • Name
    exemptHST
    Type
    number Required
    Description
  • Name
    exemptPST
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description
  • Name
    discount
    Type
    number Required
    Description

Properties for parts object

  • Name
    exempt
    Type
    number Required
    Description
  • Name
    exemptGST
    Type
    number Required
    Description
  • Name
    exemptHST
    Type
    number Required
    Description
  • Name
    exemptPST
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description
  • Name
    discount
    Type
    number Required
    Description

Properties for shopSupplies object

  • Name
    exempt
    Type
    number Required
    Description
  • Name
    exemptGST
    Type
    number Required
    Description
  • Name
    exemptHST
    Type
    number Required
    Description
  • Name
    exemptPST
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description

Properties for subcontracts object

  • Name
    exempt
    Type
    number Required
    Description
  • Name
    exemptGST
    Type
    number Required
    Description
  • Name
    exemptHST
    Type
    number Required
    Description
  • Name
    exemptPST
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description
  • Name
    discount
    Type
    number Required
    Description

Properties for tires object

  • Name
    exempt
    Type
    number Required
    Description
  • Name
    exemptGST
    Type
    number Required
    Description
  • Name
    exemptHST
    Type
    number Required
    Description
  • Name
    exemptPST
    Type
    number Required
    Description
  • Name
    nonTaxable
    Type
    number Required
    Description
  • Name
    nonTaxableGST
    Type
    number Required
    Description
  • Name
    nonTaxableHST
    Type
    number Required
    Description
  • Name
    nonTaxablePST
    Type
    number Required
    Description
  • Name
    taxable
    Type
    number Required
    Description
  • Name
    taxableGST
    Type
    number Required
    Description
  • Name
    taxableHST
    Type
    number Required
    Description
  • Name
    taxablePST
    Type
    number Required
    Description
  • Name
    discount
    Type
    number Required
    Description

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request

GET
/v3/report/line_item_sales_tax
curl https://api.shopmonkey.cloud/v3/report/line_item_sales_tax \
  -H "Authorization: Bearer ${SM_TOKEN}"

Example Response
application/json

{
  "success": true,
  "data": {
    "parts": {
      "taxable": 1,
      "nonTaxable": 1,
      "exempt": 1,
      "discount": 1
    },
    "labors": {
      "taxable": 1,
      "nonTaxable": 1,
      "exempt": 1,
      "discount": 1
    },
    "tires": {
      "taxable": 1,
      "nonTaxable": 1,
      "exempt": 1,
      "discount": 1
    },
    "subcontracts": {
      "taxable": 1,
      "nonTaxable": 1,
      "exempt": 1,
      "discount": 1
    },
    "fees": {
      "nonTaxable": 1
    },
    "epa": {
      "taxable": 1,
      "nonTaxable": 1,
      "exempt": 1
    },
    "shopSupplies": {
      "taxable": 1,
      "nonTaxable": 1,
      "exempt": 1
    },
    "taxesTotal": 1,
    "gstTotal": 1,
    "pstTotal": 1,
    "hstTotal": 1,
    "taxesOwed": 1,
    "gstOwed": 1,
    "pstOwed": 1,
    "hstOwed": 1
  }
}

POST/v3/report/technicians/summary

Summary By Tech Report

Summary By Tech Report

Body parameters

Consumes

The following content type is required: application/json


Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    inbox
    Type
    string
    Description
    The inbox subject to listen to for a response
  • Name
    success
    Type
    one of: any, 'true'
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message
  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    array
    Description
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request
application/json

POST
/v3/report/technicians/summary
curl https://api.shopmonkey.cloud/v3/report/technicians/summary \
  -H "Authorization: Bearer ${SM_TOKEN}" \
  -H 'Content-Type: application/json' \
  --data '{}'

Example Response
application/json

{
  "success": true,
  "data": [
    {
      "general_hours_tracked": 1,
      "order_hours_tracked": 1,
      "technicianFirstName": "technicianFirstName",
      "technicianId": "technicianId",
      "technicianLaborRate": 1,
      "technicianLastName": "technicianLastName",
      "total_billed_hours": 1,
      "total_cost_hours": 1,
      "total_hours_tracked": 1,
      "total_labor_billed": 1,
      "total_labor_cost": 1,
      "vehicle_count": 1
    }
  ]
}

POST/v3/report/technicians/services

Services By Tech Report

Services By Tech Report

Body parameters

Consumes

The following content type is required: application/json


Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    inbox
    Type
    string
    Description
    The inbox subject to listen to for a response
  • Name
    success
    Type
    one of: any, 'true' Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message
  • Name
    data
    Type
    array
    Description
  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request
application/json

POST
/v3/report/technicians/services
curl https://api.shopmonkey.cloud/v3/report/technicians/services \
  -H "Authorization: Bearer ${SM_TOKEN}" \
  -H 'Content-Type: application/json' \
  --data '{}'

Example Response
application/json

{
  "data": [
    {
      "dates": "2024-01-23T21:56:24.676Z",
      "orderCoalescedName": "orderCoalescedName",
      "orderId": "orderId",
      "orderNumber": "orderNumber",
      "serviceId": "serviceId",
      "serviceName": "serviceName",
      "service_hours_tracked": 1,
      "technicianFirstName": "technicianFirstName",
      "technicianId": "technicianId",
      "technicianLaborRate": 1,
      "technicianLastName": "technicianLastName",
      "total_billed_hours": 1,
      "total_cost_hours": 1,
      "total_labor_billed": 1,
      "total_labor_cost": 1
    }
  ],
  "success": true
}

POST/v3/report/line_item_detail

Line Item Details report

Line Item Details report

Body parameters

Consumes

The following content type is required: application/json

  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description
  • Name
    limit
    Type
    number
    Description
    the limit on the number of records to return
  • Name
    orderBy
    Type
    one of: any, any
    Description
    the order instructions for the result
  • Name
    skip
    Type
    number
    Description
    the number of records to skip for a paginated result
  • Name
    locationIds
    Type
    array
    Description
  • Name
    where
    Type
    object Required
    Description

Properties for where object

  • Name
    archived
    Type
    boolean
    Description
    Whether to include archived orders
  • Name
    categoryIds
    Type
    array
    Description
  • Name
    customerIds
    Type
    array
    Description
  • Name
    invoicedDate
    Type
    object
    Description
  • Name
    locationIds
    Type
    array
    Description
  • Name
    paidStatus
    Type
    one of: paid, unpaid, overdue
    Description
    Paid status
  • Name
    technicianIds
    Type
    array
    Description
  • Name
    vendorIds
    Type
    array
    Description
  • Name
    workflowStatusIds
    Type
    array
    Description
  • Name
    type
    Type
    array
    Description
  • Name
    fullyPaidDate
    Type
    object
    Description
  • Name
    orderStatus
    Type
    array
    Description

Properties for invoicedDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Properties for fullyPaidDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    array Required
    Description
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request
application/json

POST
/v3/report/line_item_detail
curl https://api.shopmonkey.cloud/v3/report/line_item_detail \
  -H "Authorization: Bearer ${SM_TOKEN}" \
  -H 'Content-Type: application/json' \
  --data '{ "where" : {} }'

Example Response
application/json

{
  "data": [
    {
      "__lastRefreshedAt": "__lastRefreshedAt",
      "brandId": null,
      "brandName": null,
      "companyId": "companyId",
      "createdDate": "createdDate",
      "customer": {
        "address1": null,
        "address2": null,
        "city": null,
        "companyName": null,
        "country": null,
        "customerType": null,
        "id": null,
        "normalizedFirstName": null,
        "normalizedLastName": null,
        "postalCode": null,
        "state": null
      },
      "customerId": null,
      "discountCents": null,
      "discountPercent": null,
      "discountValueType": null,
      "feeAmountCents": null,
      "feeId": null,
      "feeLineItemEntity": null,
      "feePercent": null,
      "feeType": null,
      "id": "id",
      "inventoryCategoryId": null,
      "inventoryCategoryName": null,
      "inventorySubCategoryId": null,
      "inventorySubCategoryName": null,
      "labels": [
        "labels"
      ],
      "laborCompletedDate": null,
      "laborHours": null,
      "laborId": null,
      "laborMatrixId": null,
      "laborMultiplier": 1,
      "laborMultiplierType": null,
      "laborRateCents": null,
      "locationId": "locationId",
      "name": null,
      "note": null,
      "orderArchived": true,
      "orderCompletedDate": null,
      "orderDueDate": null,
      "orderFullyPaidDate": null,
      "orderGeneratedVehicleName": null,
      "orderId": "orderId",
      "orderInvoicedDate": null,
      "orderLabels": [
        "orderLabels"
      ],
      "orderName": null,
      "orderNumber": "orderNumber",
      "orderPaidStatus": null,
      "orderTaxCents": 1,
      "orderTotalCostCents": 1,
      "orderType": null,
      "orderWorkflowStatusId": null,
      "orderWorkflowStatusName": null,
      "partId": null,
      "partNumber": null,
      "pricingMatrixDate": null,
      "pricingMatrixId": null,
      "pricingMatrixRangeId": null,
      "pricingMatrixRangeMarkupMarginPercent": null,
      "pricingMatrixRangeMarkupPercent": null,
      "quantity": null,
      "retailCostCents": null,
      "subcontractCostCents": null,
      "subcontractId": null,
      "subcontractRetailCostCents": null,
      "subtotalCents": null,
      "technician": {
        "firstName": null,
        "id": null,
        "lastName": null
      },
      "technicianId": null,
      "tireCalculatedName": null,
      "tireFederalExciseTaxCents": null,
      "tireId": null,
      "tireIdentificationNumbers": [
        "tireIdentificationNumbers"
      ],
      "tireInventoryStatus": null,
      "tireModelId": null,
      "tireSize": null,
      "tireSizeFormat": null,
      "tireWasteTireFee": null,
      "type": "type",
      "updatedDate": null,
      "vehicle": {
        "hin": null,
        "id": null,
        "licensePlate": null,
        "licensePlateCountry": null,
        "licensePlateState": null,
        "type": null,
        "unit": null,
        "vin": null
      },
      "vehicleId": null,
      "vendorId": null,
      "vendorName": null,
      "wholesaleCostCents": null
    }
  ],
  "success": true
}

POST/v3/report/line_item_detail_by_type

Line Item detail by category report

Line Item Detail by type report

Body parameters

Consumes

The following content type is required: application/json

  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description
  • Name
    limit
    Type
    number
    Description
    the limit on the number of records to return
  • Name
    orderBy
    Type
    one of: any, any
    Description
    the order instructions for the result
  • Name
    skip
    Type
    number
    Description
    the number of records to skip for a paginated result
  • Name
    locationIds
    Type
    array
    Description
  • Name
    where
    Type
    object Required
    Description

Properties for where object

  • Name
    archived
    Type
    boolean
    Description
    Whether to include archived orders
  • Name
    categoryIds
    Type
    array
    Description
  • Name
    customerIds
    Type
    array
    Description
  • Name
    invoicedDate
    Type
    object
    Description
  • Name
    locationIds
    Type
    array
    Description
  • Name
    paidStatus
    Type
    one of: paid, unpaid, overdue
    Description
    Paid status
  • Name
    technicianIds
    Type
    array
    Description
  • Name
    vendorIds
    Type
    array
    Description
  • Name
    workflowStatusIds
    Type
    array
    Description
  • Name
    type
    Type
    array
    Description
  • Name
    fullyPaidDate
    Type
    object
    Description
  • Name
    orderStatus
    Type
    array
    Description

Properties for invoicedDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Properties for fullyPaidDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message
  • Name
    data
    Type
    object Required
    Description

Properties for data object

  • Name
    rows
    Type
    array Required
    Description
  • Name
    sums
    Type
    object Required
    Description
  • Name
    lastRefreshedAt
    Type
    string
    Description

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request
application/json

POST
/v3/report/line_item_detail_by_type
curl https://api.shopmonkey.cloud/v3/report/line_item_detail_by_type \
  -H "Authorization: Bearer ${SM_TOKEN}" \
  -H 'Content-Type: application/json' \
  --data '{ "where" : {} }'

Example Response
application/json

{
  "success": true,
  "data": {
    "rows": [
      {
        "months": {},
        "type": "type"
      }
    ],
    "sums": {},
    "lastRefreshedAt": "lastRefreshedAt"
  }
}

POST/v3/report/line_item_detail_by_category

Line Item Detail by category report

Line Item Detail by category report

Body parameters

Consumes

The following content type is required: application/json

  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description
  • Name
    limit
    Type
    number
    Description
    the limit on the number of records to return
  • Name
    orderBy
    Type
    one of: any, any
    Description
    the order instructions for the result
  • Name
    skip
    Type
    number
    Description
    the number of records to skip for a paginated result
  • Name
    locationIds
    Type
    array
    Description
  • Name
    where
    Type
    object Required
    Description

Properties for where object

  • Name
    archived
    Type
    boolean
    Description
    Whether to include archived orders
  • Name
    categoryIds
    Type
    array
    Description
  • Name
    customerIds
    Type
    array
    Description
  • Name
    invoicedDate
    Type
    object
    Description
  • Name
    locationIds
    Type
    array
    Description
  • Name
    paidStatus
    Type
    one of: paid, unpaid, overdue
    Description
    Paid status
  • Name
    technicianIds
    Type
    array
    Description
  • Name
    vendorIds
    Type
    array
    Description
  • Name
    workflowStatusIds
    Type
    array
    Description
  • Name
    type
    Type
    array
    Description
  • Name
    fullyPaidDate
    Type
    object
    Description
  • Name
    orderStatus
    Type
    array
    Description

Properties for invoicedDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Properties for fullyPaidDate object

  • Name
    gte
    Type
    string
    Description
    optional greaterThanEqual date param
  • Name
    lte
    Type
    string
    Description
    optional lessThanEqual date param
  • Name
    period
    Type
    one of: 'allTime', 'before', 'custom', 'lastMonth', 'lastWeek', 'nextMonth', 'nextWeek', 'thisMonth', 'thisWeek', 'today', 'tomorrow', 'yearToDate', 'yesterday' Required
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message
  • Name
    data
    Type
    object Required
    Description

Properties for data object

  • Name
    rows
    Type
    array Required
    Description
  • Name
    sums
    Type
    object Required
    Description
  • Name
    lastRefreshedAt
    Type
    string
    Description

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request
application/json

POST
/v3/report/line_item_detail_by_category
curl https://api.shopmonkey.cloud/v3/report/line_item_detail_by_category \
  -H "Authorization: Bearer ${SM_TOKEN}" \
  -H 'Content-Type: application/json' \
  --data '{ "where" : {} }'

Example Response
application/json

{
  "success": true,
  "data": {
    "rows": [
      {
        "months": {},
        "inventoryCategoryName": null,
        "inventorySubCategoryName": null
      }
    ],
    "sums": {},
    "lastRefreshedAt": "lastRefreshedAt"
  }
}

POST/v3/report/referral_summary

Referral Summary report

Referral Summary Report

Body parameters

Consumes

The following content type is required: application/json

  • Name
    ids
    Type
    array
    Description
  • Name
    limit
    Type
    number
    Description
    the limit on the number of records to return
  • Name
    orderby
    Type
    string
    Description
    the order instructions for the result
  • Name
    params
    Type
    string
    Description
    additional request specific params
  • Name
    skip
    Type
    number
    Description
    the number of records to skip for a paginated result
  • Name
    where
    Type
    one of: any, any
    Description
    an object to use for filtering the results
  • Name
    orderBy
    Type
    one of: any, any
    Description
    the order instructions for the result
  • Name
    columns
    Type
    array
    Description
    Array of column names to export
  • Name
    format
    Type
    string
    Description

Produces

The response produces the following content types: application/json, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

200 Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    array Required
    Description
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if success = false
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

4xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

5xx Response

  • Name
    code
    Type
    string
    Description
    The error code
  • Name
    data
    Type
    object
    Description
    An optional object containing relevant error data
  • Name
    documentation_url
    Type
    string
    Description
    An optional link to the documentation for the error
  • Name
    message
    Type
    string
    Description
    the error message if not successful
  • Name
    success
    Type
    boolean Required
    Description
    if successful, will be true. if not successful, will be false and message will contain a human readable error message

Example Request
application/json

POST
/v3/report/referral_summary
curl https://api.shopmonkey.cloud/v3/report/referral_summary \
  -H "Authorization: Bearer ${SM_TOKEN}" \
  -H 'Content-Type: application/json' \
  --data '{}'

Example Response
application/json

{
  "data": [
    {
      "__lastRefreshedAt": "__lastRefreshedAt",
      "customerCount": 1,
      "ownershipPercent": 1,
      "retailCostCents": 1,
      "sourceId": null,
      "sourceName": null
    }
  ],
  "success": true
}