Get data from audit responses for matrix generation
GET {{baseUrl}}/v1/ws/:workspaceId/AuditResponses/matrix/:templateId?areaId=61551403&q=eu&parentId=90244082-e0f0-7c09-2426-64e4431d1d9d&states=<string>&states=<string>&templateIds=d4f4baa2-55ee-3f4c-0ca0-c6deaeed0857&templateIds=urn:uuid:ff11db24-69a8-3ad2-d3e2-f5cb64653a1d&minReadiness=61551403&maxReadiness=61551403&NeedRenew=true&objectType=<string>&objectId=eu&respondantIds=88057944&respondantIds=-17779712&ownerIds=88057944&ownerIds=-17779712&ids=d4f4baa2-55ee-3f4c-0ca0-c6deaeed0857&ids=urn:uuid:ff11db24-69a8-3ad2-d3e2-f5cb64653a1d&Type=<string>&archived=true&includeGraphs=true&includeTasks=true&select=eu&page=61551403&size=61551403&skip=61551403&sortBy=eu&asc=true&filters=eu&rowLevel=Question
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
areaId | number | ||
q | string | ||
parentId | string | ||
states | string | ||
states | string | ||
templateIds | string | ||
templateIds | string | ||
minReadiness | number | ||
maxReadiness | number | ||
NeedRenew | boolean | ||
objectType | string | ||
objectId | string | ||
respondantIds | number | ||
respondantIds | number | ||
ownerIds | number | ||
ownerIds | number | ||
ids | string | ||
ids | string | ||
Type | string | ||
archived | boolean | ||
includeGraphs | boolean | ||
includeTasks | boolean | ||
select | string | Comma separated list of fields | |
page | number | Pagination index (1 based, page 1 = 1, page 2 = 2...) | |
size | number | Size of the result page (default: 20, max 500) | |
skip | number | The number of items to skip (if not provided, it will use the default page and size prop) | |
sortBy | string | The field to sort | |
asc | boolean | True to sort ascending | |
filters | string | A serialized as json filter string using the JsonRuleEngine.net format | |
https://github.com/antoinebidault/JsonRuleEngine.Net | |||
The filters is a query param, that's why he must be properly serialized as a json string and url encoded | |||
e.g. {"field":"ProcessingType", "operator":"notEqual", "value": "Done"} | |||
The field prop must match one property name of the object (present in the output results) | |||
The operator can be equal, | |||
notEqual, | |||
lessThan, | |||
lessThanInclusive, | |||
greaterThan, | |||
greaterThanInclusive, | |||
in, | |||
notIn, | |||
contains, | |||
doesNotContains, | |||
isNull, | |||
isNotNull, | |||
isEmpty | |||
You can combine the filters as following : | |||
{ "separator":"Or","rules": [{"field":"ProcessingType", "operator":"notEqual", "value": "Done"},{"field":"ProcessingType", "operator":"isNull"}]} | |||
Serialize the filter param as following: | |||
?filters=${uriEncodeComponent(JSON.stringify({"field":"ProcessingType", "operator":"notEqual", "value": "Done"}))} | |||
rowLevel | string |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Accept | string |
RESPONSES
status: OK
{"template":{"label":"commodo Excepteur sunt","sections":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"resultAnalysis":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"id":"eb64d7a5-7cd5-adb7-fd2d-4cbe00ab10a2","version":"cillum mollit proident","newVersion":false,"isPinned":true,"isRevision":true,"isBlockAnalysisShared":true,"nbReferences":-42226501,"referenceId":"urn:uuid:220aa9b5-2857-d3bb-a6eb-f7eb86594bea","nbResponses":-64945740,"parentId":"135049b0-2035-36e0-5697-fdae0a87b7c2","revisionDescription":"anim","logoUrl":"https://dgNAIMjAfLevFJarY.prnjS9RnKsmdkxpvyUlk4ThuCB1QMDkDmIPRXpWyc8,SBPRFVL5Zm2KPHM7UV0HZhdw","description":"fugiat in dolor","scheduleIntervalDays":23208825,"versionNumber":35834788,"dateCreation":"1966-03-23T00:52:26.652Z","dateUpdate":"1999-06-22T14:49:28.829Z","type":"LIA","creator":{"id":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"displayName":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"familyName":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"givenName":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"email":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"color":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"avatarUrl":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"tenantId":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}},"objectType":"\u003cstring\u003e","defaultOwners":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"tags":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"nbQuestions":-56486121,"nbQuestionsRequired":-62948970,"nbDatas":-48367965},"columns":[{"id":"urn:uuid:cd082836-6bc5-1189-1c2c-d16961c5b379","name":"ad culpa","rateCompletion":84875770.27386743,"rateScore":30304262.671877652,"owners":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"state":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"publishedDate":"1985-06-14T18:54:25.598Z"},{"id":"urn:uuid:389733fb-c1c1-071f-22a2-966aa570884c","name":"magna ullamco incididunt","rateCompletion":7017628.574738979,"rateScore":-58048728.979098566,"owners":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"state":{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},"publishedDate":"1991-10-08T07:54:04.795Z"}],"rows":[{"logoUrl":"ad adipisicing","label":"in incididunt","rateCompletion":-13852618.470414147,"rateScore":20684179.579056308,"totalCompletion":65651719,"totalScore":-44440633.724644884,"totalMaxScore":25014552.991880372,"values":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"nbQuestions":19213728},{"logoUrl":"pariatur cupidatat","label":"ex labore","rateCompletion":32459280.588025004,"rateScore":16393595.498382226,"totalCompletion":98953548,"totalScore":44826776.91790271,"totalMaxScore":-97076327.98227914,"values":[{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"},{"value":"\u003cError: Too many levels of nesting to fake this schema\u003e"}],"nbQuestions":52800073}],"rateScore":38591011.85085109}