Retrieve a profitloss

Updated:

GET/accounting/{connection_id}/profitloss/{id}

Retrieves a single AccountingProfitloss by its `id`. Obtain `id` values from the corresponding list endpoint. Use `fields` to return only the fields you need.

Parameters

fieldsstring array
Fields to return
rawstring
Raw parameters to include in the 3rd-party request. Encoded as a URL component. eg. raw parameters: foo=bar&zoo=bar -> raw=foo%3Dbar%26zoo%3Dbar
connection_idstring required
ID of the connection
idstring required
ID of the Profitloss

Returns

Response fieldTypeRequiredDescription
idstringNo
created_atstring (date-time)No(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
updated_atstring (date-time)No(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
category_idsstring[]No(reference to AccountingCategory)
start_atstring (date-time)No(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
end_atstring (date-time)No(ISO-8601 / YYYY-MM-DDTHH:MM:SSZ format)
namestringNo
currencystringNo
income_total_amountnumberNo
net_income_amountnumberNo
expenses_total_amountnumberNo
cost_of_goods_sold_total_amountnumberNo
income_sectionsAccountingProfitlossSection[]No
income_sections[].section_typestringNo
income_sections[].section_namestringNo
income_sections[].total_amountnumberNo
income_sections[].accountsAccountingProfitlossAccount[]No
income_sections[].accounts[].account_idstringNo(reference to AccountingAccount)
income_sections[].accounts[].account_namestringNo
income_sections[].accounts[].total_amountnumberNo
income_sections[].accounts[].transaction_idsstring[]No
expenses_sectionsAccountingProfitlossSection[]No
expenses_sections[].section_typestringNo
expenses_sections[].section_namestringNo
expenses_sections[].total_amountnumberNo
expenses_sections[].accountsAccountingProfitlossAccount[]No
expenses_sections[].accounts[].account_idstringNo(reference to AccountingAccount)
expenses_sections[].accounts[].account_namestringNo
expenses_sections[].accounts[].total_amountnumberNo
expenses_sections[].accounts[].transaction_idsstring[]No
cost_of_goods_sold_sectionsAccountingProfitlossSection[]No
cost_of_goods_sold_sections[].section_typestringNo
cost_of_goods_sold_sections[].section_namestringNo
cost_of_goods_sold_sections[].total_amountnumberNo
cost_of_goods_sold_sections[].accountsAccountingProfitlossAccount[]No
cost_of_goods_sold_sections[].accounts[].account_idstringNo(reference to AccountingAccount)
cost_of_goods_sold_sections[].accounts[].account_namestringNo
cost_of_goods_sold_sections[].accounts[].total_amountnumberNo
cost_of_goods_sold_sections[].accounts[].transaction_idsstring[]No
metadataAccountingMetadata[]No
metadata[].idstringNoThe ID of the custom field definition (from the metadata/metadata endpoint).
metadata[].slugstringNoThe integration's API name (key) of an existing custom field. List valid slugs for this object with the metadata/metadata endpoint; unknown slugs are rejected by the integration.
metadata[].valueobjectNoThe field's value, typed by `format`: DATE as ISO-8601 (`YYYY-MM-DD`, or `YYYY-MM-DDTHH:MM:SSZ` for date-times); NUMBER, PRICE and CURRENCY as a number; BOOLEAN and YES_NO as true/false; MULTIPLE_SELECT as an array of option values; otherwise a string.
metadata[].namespacestringNo
metadata[].formatenumNoThe data type of the custom field, which determines how `value` is formatted. Values: TEXT, NUMBER, DATE, BOOLEAN, FILE, TEXTAREA, SINGLE_SELECT, MULTIPLE_SELECT, MEASUREMENT, PRICE, YES_NO, CURRENCY, URL
metadata[].extra_dataobjectNo

Errors

Errors return the HTTP status code and a JSON body with statusCode, error (the short label) and message (a human-readable detail).

{
  "statusCode": 429,
  "error": "Too Many Requests",
  "message": "Too many requests to unified.to API; max requests per minute: N"
}
StatusErrorMeaning
400Bad RequestThe request was malformed or failed validation.
401UnauthorizedThe connection is likely broken; re-authorize it.
403ForbiddenThe connection is missing permissions or scopes.
404Not FoundThe requested resource does not exist.
429Too Many RequestsRate limit exceeded (see the two sources below).
500Internal Server ErrorAn unexpected error occurred.
501Not ImplementedNot supported by this integration.

Errors from the underlying integration pass through: the integration's status comes back as ours (429, 401, 403, 404 or 5xx), usually with its message. When the integration's error body is unclear, Unified extracts what it can and returns a clearer message.

429 Too Many Requests

A 429 has two possible sources:

  • The integration's own rate limit, passed through.
  • Unified's workspace limit: a rolling 60 seconds, set by plan, with the message Too many requests to unified.to API; max requests per minute: N.
const options = {
  method: 'GET',
  url: 'https://api.unified.to/accounting/5de520f96e439b002043d8dc/profitloss/5de520f96e439b002043d8d8',
  headers: {
    authorization: 'bearer .....'
  },
  params: {
    fields: '',
    raw: '',
  }
};

const results = await axios.request(options);
Are we missing anything? Let us know
Was this page helpful?