Get Metrics | Mercoa | Documentation

Authentication

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Path parameters

entityGroupIdstringRequired

Entity Group ID or Entity Group ForeignID

Query parameters

searchstringOptional

Find invoices by vendor name, invoice number, check number, or amount. Partial matches are supported.

excludePayablesbooleanOptional

Only return invoices that are not payable by the entity. This will return only invoices that are receivable by the entity.

excludeReceivablesbooleanOptional

Only return invoices that are not receivable by the entity. This will return only invoices that are payable by the entity.

returnByDateenumOptional

Return invoice metrics grouped by date.

Allowed values:

returnByDateFrequencyenumOptional

Return invoice metrics grouped by date. Defaults to daily.

Allowed values:

groupByenumOptional

Return invoice metrics grouped by.

Allowed values:

payerIdstringOptional

Filter invoices by payer ID.

vendorIdstringOptional

Filter invoices by vendor ID.

approverIdstringOptional

Filter invoices by assigned approver user ID.

approverCountstringOptional

Filter invoices by the number of approvers. Use exact number (e.g., 3) or range (e.g., ">3", "<5", ">=2", "<=4").

invoiceIdstringOptional

Filter invoices by invoice ID or invoice foreign ID.

statusenumOptional

Invoice status to filter on

startDatedatetimeOptional

Start date filter. Defaults to CREATED_AT unless specified the dateType is specified

endDatedatetimeOptional

End date filter. Defaults to CREATED_AT unless specified the dateType is specified

dateTypeenumOptional

Type of date to filter by if startDate and endDate filters are provided. Defaults to CREATED_AT.

currencyenumOptional

Currency to filter on

Response

This endpoint returns a list of objects.

totalAmountdouble

totalCountinteger

averageAmountdouble

currencyenum

grouplist of maps from strings to strings or null

If groupBy is provided, this will be the group by value.

datesmap from strings to objects or null

1	import datetime
2
3	from mercoa import Mercoa
4
5	client = Mercoa(
6	token="YOUR_TOKEN",
7	)
8	client.entity_group.invoice.metrics(
9	entity_group_id="entg_8545a84e-a45f-41bf-bdf1-33b42a55812c",
10	return_by_date="CREATION_DATE",
11	exclude_receivables=True,
12	start_date=datetime.datetime.fromisoformat(
13	"2021-01-01 00:00:00+00:00",
14	),
15	end_date=datetime.datetime.fromisoformat(
16	"2021-01-31 23:59:59.999000+00:00",
17	),
18	currency="USD",
19	status="NEW",
20	)

1	[
2	{
3	"totalAmount": 1000,
4	"totalCount": 10,
5	"averageAmount": 100,
6	"currency": "USD",
7	"dates": {
8	"2021-01-01T00:00:00Z": {
9	"date": "2021-01-01T00:00:00Z",
10	"totalAmount": 100,
11	"totalCount": 1,
12	"averageAmount": 100,
13	"currency": "USD"
14	},
15	"2021-01-02T00:00:00Z": {
16	"date": "2021-01-02T00:00:00Z",
17	"totalAmount": 200,
18	"totalCount": 2,
19	"averageAmount": 100,
20	"currency": "USD"
21	},
22	"2021-01-03T00:00:00Z": {
23	"date": "2021-01-03T00:00:00Z",
24	"totalAmount": 400,
25	"totalCount": 2,
26	"averageAmount": 200,
27	"currency": "USD"
28	}
29	}
30	}
31	]

Authentication

Path parameters

Query parameters

Response

Errors