Get a DM Object (no count)

post/datamart.fetchnocount/{objectId}

Retrieves the object's (Data Feed, Data Source, Datamart) row level data and skips the count() query - it does not return a total number of rows in the entire table when the filter is applied, it returns just the total number of rows in the response.

Information: Use this endpoint when you need a better performance when fetching large data sets and when you do not need to fetch a total number of items in the table. Usually used for integration purposes.

Securitybasic or X-PriceFx-jwt
Request
path Parameters
objectId
required
string

Use one of the following object identifiers:

  • typedUniquename – Format: "<typeCode>.<uniqueName>" (e.g., DMDS.SalesTransactions)
  • typedId – Format: "<dbId>.<typeCode>" (e.g., 123456.DMDS)
  • "*" (asterisk) – Asterisk can be used when you are providing a source$query in data within the request body
Request Body schema: application/json
endRow
number
oldValues
any
operationType
string non-empty
startRow
number
textMatchStyle
string non-empty
object
_constructor
string non-empty
operator
string non-empty
Array of objects non-empty unique
Array (non-empty)
fieldName
string non-empty
operator
string non-empty
value
string non-empty
Responses
200

OK

Response Schema: application/json
object
node
string non-empty
csrfToken
string non-empty
startRow
number
data
Array of objects non-empty unique
endRow
number
totalRows
number
status
number
Request samples
application/json
{
  • "endRow": 300,
  • "oldValues": null,
  • "operationType": "fetch",
  • "startRow": 0,
  • "textMatchStyle": "exact",
  • "data": {
    • "_constructor": "AdvancedCriteria",
    • "operator": "and",
    • "criteria": [
      • {
        • "fieldName": "attribute4",
        • "operator": "iEquals",
        • "value": "EUR"
        }
      ]
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "string",
    • "csrfToken": "string",
    • "startRow": 0,
    • "data": [
      • { }
      ],
    • "endRow": 0,
    • "totalRows": 0,
    • "status": 0
    }
}