Hi everbody,
we use a DMS system (ecoDMS) with an API. I want to extract some information from it.
Manually (with curl) I can connect with the api.
The results is an json array like
[{"docId":11388,"clDocId":11402,"archiveName":"1","classifyAttributes":{"dyn_2_1580936356174":"prüfen und freigeben","docart":"5","docid":"11388#11402","defdate":"","changeid":"x.x","dyn_1_1580936356174":"ER548","dyn_0_1580936356172":"2023","revision":"1.0","rechte":"W","folder":"1","cdate":"2023-07-04","bemerkung":"per Lastschrifteinzug","ctimestamp":"2023-07-12 12:09:25","mainfolder":"","status":"1"},"editRoles":["r_x","r_LDAP_5000-rg","r_LDAP_100-rg","r_LDAP_100-buero"],"readRoles":[]},{"docId":11387,"clDocId":11401,"archiveName":"1","classifyAttributes":{"dyn_2_1580936356174":"prüfen und freigeben","docart":"5","docid":"11387#11401","defdate":"","changeid":"x.x","dyn_1_1580936356174":"ER547","dyn_0_1580936356172":"2023","revision":"1.0","rechte":"W","folder":"1","cdate":"2023-07-12","bemerkung":" überweisen","ctimestamp":"2023-07-12 12:07:21","mainfolder":"","status":"1"},"editRoles":["r_x_x","r_LDAP_4000-rg","r_LDAP_100-rg","r_LDAP_100-buero"],"readRoles":[]}]
I want to create a sensor which gives back all 'dyn_0_ … ’ concatenated. I tried a lot of things, but I’m not succesful up ti now.
As a Query, I would take ‘[*].classifyAttributes.dyn_1_1580936356174’, maybe that converted to a string with join().
This will not work with RESTFUL.
Can anybody help me?