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

KeyDatatypeRequiredDescription
areaIdnumber
qstring
parentIdstring
statesstring
statesstring
templateIdsstring
templateIdsstring
minReadinessnumber
maxReadinessnumber
NeedRenewboolean
objectTypestring
objectIdstring
respondantIdsnumber
respondantIdsnumber
ownerIdsnumber
ownerIdsnumber
idsstring
idsstring
Typestring
archivedboolean
includeGraphsboolean
includeTasksboolean
selectstringComma separated list of fields
pagenumberPagination index (1 based, page 1 = 1, page 2 = 2...)
sizenumberSize of the result page (default: 20, max 500)
skipnumberThe number of items to skip (if not provided, it will use the default page and size prop)
sortBystringThe field to sort
ascbooleanTrue to sort ascending
filtersstringA 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"}))}
rowLevelstring

HEADERS

KeyDatatypeRequiredDescription
Acceptstring

RESPONSES

status: OK

{&quot;template&quot;:{&quot;label&quot;:&quot;commodo Excepteur sunt&quot;,&quot;sections&quot;:[{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;}],&quot;resultAnalysis&quot;:[{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;}],&quot;id&quot;:&quot;eb64d7a5-7cd5-adb7-fd2d-4cbe00ab10a2&quot;,&quot;version&quot;:&quot;cillum mollit proident&quot;,&quot;newVersion&quot;:false,&quot;isPinned&quot;:true,&quot;isRevision&quot;:true,&quot;isBlockAnalysisShared&quot;:true,&quot;nbReferences&quot;:-42226501,&quot;referenceId&quot;:&quot;urn:uuid:220aa9b5-2857-d3bb-a6eb-f7eb86594bea&quot;,&quot;nbResponses&quot;:-64945740,&quot;parentId&quot;:&quot;135049b0-2035-36e0-5697-fdae0a87b7c2&quot;,&quot;revisionDescription&quot;:&quot;anim&quot;,&quot;logoUrl&quot;:&quot;https://dgNAIMjAfLevFJarY.prnjS9RnKsmdkxpvyUlk4ThuCB1QMDkDmIPRXpWyc8,SBPRFVL5Zm2KPHM7UV0HZhdw&quot;,&quot;description&quot;:&quot;fugiat in dolor&quot;,&quot;scheduleIntervalDays&quot;:23208825,&quot;versionNumber&quot;:35834788,&quot;dateCreation&quot;:&quot;1966-03-23T00:52:26.652Z&quot;,&quot;dateUpdate&quot;:&quot;1999-06-22T14:49:28.829Z&quot;,&quot;type&quot;:&quot;LIA&quot;,&quot;creator&quot;:{&quot;id&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},&quot;displayName&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},&quot;familyName&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},&quot;givenName&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},&quot;email&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},&quot;color&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},&quot;avatarUrl&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},&quot;tenantId&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;}},&quot;objectType&quot;:&quot;\u003cstring\u003e&quot;,&quot;defaultOwners&quot;:[{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;}],&quot;tags&quot;:[{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;}],&quot;nbQuestions&quot;:-56486121,&quot;nbQuestionsRequired&quot;:-62948970,&quot;nbDatas&quot;:-48367965},&quot;columns&quot;:[{&quot;id&quot;:&quot;urn:uuid:cd082836-6bc5-1189-1c2c-d16961c5b379&quot;,&quot;name&quot;:&quot;ad culpa&quot;,&quot;rateCompletion&quot;:84875770.27386743,&quot;rateScore&quot;:30304262.671877652,&quot;owners&quot;:[{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;}],&quot;state&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},&quot;publishedDate&quot;:&quot;1985-06-14T18:54:25.598Z&quot;},{&quot;id&quot;:&quot;urn:uuid:389733fb-c1c1-071f-22a2-966aa570884c&quot;,&quot;name&quot;:&quot;magna ullamco incididunt&quot;,&quot;rateCompletion&quot;:7017628.574738979,&quot;rateScore&quot;:-58048728.979098566,&quot;owners&quot;:[{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;}],&quot;state&quot;:{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},&quot;publishedDate&quot;:&quot;1991-10-08T07:54:04.795Z&quot;}],&quot;rows&quot;:[{&quot;logoUrl&quot;:&quot;ad adipisicing&quot;,&quot;label&quot;:&quot;in incididunt&quot;,&quot;rateCompletion&quot;:-13852618.470414147,&quot;rateScore&quot;:20684179.579056308,&quot;totalCompletion&quot;:65651719,&quot;totalScore&quot;:-44440633.724644884,&quot;totalMaxScore&quot;:25014552.991880372,&quot;values&quot;:[{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;}],&quot;nbQuestions&quot;:19213728},{&quot;logoUrl&quot;:&quot;pariatur cupidatat&quot;,&quot;label&quot;:&quot;ex labore&quot;,&quot;rateCompletion&quot;:32459280.588025004,&quot;rateScore&quot;:16393595.498382226,&quot;totalCompletion&quot;:98953548,&quot;totalScore&quot;:44826776.91790271,&quot;totalMaxScore&quot;:-97076327.98227914,&quot;values&quot;:[{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;},{&quot;value&quot;:&quot;\u003cError: Too many levels of nesting to fake this schema\u003e&quot;}],&quot;nbQuestions&quot;:52800073}],&quot;rateScore&quot;:38591011.85085109}