Report

WIP: A summary needs to be written for Report

GET/v3/report/payment

Payments report

All Payments report

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
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
undefined
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
undefined
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)

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
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
undefined
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
undefined
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

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
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
undefined
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
undefined
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

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
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
undefined
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
undefined
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

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
undefined
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
undefined
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

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
undefined
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
undefined
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

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
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
undefined
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
undefined
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

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
undefined
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
undefined
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

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
undefined
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
undefined
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

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
undefined
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
undefined
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

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
undefined
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
undefined
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
undefined
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
undefined
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

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
undefined
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
undefined
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
undefined
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
undefined
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
}

Report

Produces

200 Response

Properties for meta object

4xx Response

5xx Response

Example Request

Example Responseapplication/json

Produces

200 Response

Properties for meta object

4xx Response

5xx Response

Example Request

Example Responseapplication/json

Produces

200 Response

Properties for meta object

4xx Response

5xx Response

Example Request

Example Responseapplication/json

Produces

200 Response

Properties for meta object

4xx Response

5xx Response

Example Request

Example Responseapplication/json

Produces

200 Response

Properties for data object

Properties for lineItems object

Properties for fees object

Properties for labors object

Properties for parts object

Properties for subcontracts object

Properties for tires object

Properties for totalsSum object

Properties for orders object

Properties for payments object

Properties for Unknown object

Properties for account_receivable object

Properties for ach object

Properties for american express object

Properties for american_express object

Properties for amex object

Properties for card object

Properties for cash object

Properties for check object

Properties for diners object

Properties for discover object

Properties for financing object

Properties for insurance object

Properties for internal object

Properties for jcb object

Properties for mastercard object

Properties for mechanical_installment object

Properties for other object

Properties for otherCards object

Properties for payPal object

Properties for policy object

Properties for reconditioning object

Properties for refunds object

Properties for total object

Properties for unionpay object

Properties for unknown object

Properties for vehicle_service_contract object

Properties for venmo object

Properties for visa object

Properties for warranty object

Properties for zelle object

Properties for performance object

Properties for sales object

4xx Response

5xx Response

Example Request

Example Responseapplication/json

Produces

200 Response

`200` Response

Properties for `meta` object

`4xx` Response

`5xx` Response

Example Response
application/json

`200` Response

Properties for `meta` object

`4xx` Response

`5xx` Response

Example Response
application/json

`200` Response

Properties for `meta` object

`4xx` Response

`5xx` Response

Example Response
application/json

`200` Response

Properties for `meta` object

`4xx` Response

`5xx` Response

Example Response
application/json

`200` Response

Properties for `data` object

Properties for `lineItems` object

Properties for `fees` object

Properties for `labors` object

Properties for `parts` object

Properties for `subcontracts` object

Properties for `tires` object

Properties for `totalsSum` object

Properties for `orders` object

Properties for `payments` object

Properties for `Unknown` object

Properties for `account_receivable` object

Properties for `ach` object

Properties for `american express` object

Properties for `american_express` object

Properties for `amex` object

Properties for `card` object

Properties for `cash` object

Properties for `check` object

Properties for `diners` object

Properties for `discover` object

Properties for `financing` object

Properties for `insurance` object

Properties for `internal` object

Properties for `jcb` object

Properties for `mastercard` object

Properties for `mechanical_installment` object

Properties for `other` object

Properties for `otherCards` object

Properties for `payPal` object

Properties for `policy` object

Properties for `reconditioning` object

Properties for `refunds` object

Properties for `total` object

Properties for `unionpay` object

Properties for `unknown` object

Properties for `vehicle_service_contract` object

Properties for `venmo` object

Properties for `visa` object

Properties for `warranty` object

Properties for `zelle` object

Properties for `performance` object

Properties for `sales` object

`4xx` Response

`5xx` Response

Example Response
application/json

`200` Response

Properties for `data` object

Properties for `allInvoices` object

Properties for `invoiced` object

Properties for `totals` object

Properties for `lostSales` object

Properties for `totals` object

Properties for `paidInvoices` object

Properties for `payments` object

Properties for `totals` object

`4xx` Response

`5xx` Response

Example Response
application/json