NEWS
(gelöst) wie Werte extrarieren?
-
Guten Morgen zusammen,
meine Telefonanlage kann bei Gesprächen Webhooks versenden,
somit bekomme ich zu jedem Telefonat folgende Werte geschickt:
{"id":"XXXXXXXXX","type":"call:update","time":XXXXXXXXX,"pbx":"XXXXXXXXXX","company":"XXXXXXXXX","integrationId":"XXXXXXX","data":{"trunkName":"XXXXXXXXX","queueId":null,"callee":{},"destination":"+XXXXXXXXXXX","flags":[],"endCause":null,"tags":[],"endBy":"","caller":{"role":"agent","groupId":"XXXXXXXXX","userAgent":"XXXXXXXXXXXXXXXXX","type":"local","userId":"XXXXXXX","license":"XXXXXXXXXX","groupName":"XXXXXXXXXX","phone":"XXXXXXXXXX","name":"XXXXXXXXXX","userExtension":"XXXXXXXXXX","company":null,"userDepartment":"Service","userDevice":"XXXXXXXXXX","email":"XXXXXXXXXX"},"queueName":null,"service":null,"endCauseStr":null,"status":"connecting"}}Mich würden aber nur die Werte "Name" und "status" interessieren und diese gerne in einen bzw. 2 Datenpunkte schreiben lassen.
Wie komme ich die gelieferten Werte am besten reduziert?
-
Guten Morgen zusammen,
meine Telefonanlage kann bei Gesprächen Webhooks versenden,
somit bekomme ich zu jedem Telefonat folgende Werte geschickt:
{"id":"XXXXXXXXX","type":"call:update","time":XXXXXXXXX,"pbx":"XXXXXXXXXX","company":"XXXXXXXXX","integrationId":"XXXXXXX","data":{"trunkName":"XXXXXXXXX","queueId":null,"callee":{},"destination":"+XXXXXXXXXXX","flags":[],"endCause":null,"tags":[],"endBy":"","caller":{"role":"agent","groupId":"XXXXXXXXX","userAgent":"XXXXXXXXXXXXXXXXX","type":"local","userId":"XXXXXXX","license":"XXXXXXXXXX","groupName":"XXXXXXXXXX","phone":"XXXXXXXXXX","name":"XXXXXXXXXX","userExtension":"XXXXXXXXXX","company":null,"userDepartment":"Service","userDevice":"XXXXXXXXXX","email":"XXXXXXXXXX"},"queueName":null,"service":null,"endCauseStr":null,"status":"connecting"}}Mich würden aber nur die Werte "Name" und "status" interessieren und diese gerne in einen bzw. 2 Datenpunkte schreiben lassen.
Wie komme ich die gelieferten Werte am besten reduziert?
@darkdevil mit dem Baustein "Atrribut von..."
namebzw.statusallerdings scheint das JSON defekt zu sein.


-
Guten Morgen zusammen,
meine Telefonanlage kann bei Gesprächen Webhooks versenden,
somit bekomme ich zu jedem Telefonat folgende Werte geschickt:
{"id":"XXXXXXXXX","type":"call:update","time":XXXXXXXXX,"pbx":"XXXXXXXXXX","company":"XXXXXXXXX","integrationId":"XXXXXXX","data":{"trunkName":"XXXXXXXXX","queueId":null,"callee":{},"destination":"+XXXXXXXXXXX","flags":[],"endCause":null,"tags":[],"endBy":"","caller":{"role":"agent","groupId":"XXXXXXXXX","userAgent":"XXXXXXXXXXXXXXXXX","type":"local","userId":"XXXXXXX","license":"XXXXXXXXXX","groupName":"XXXXXXXXXX","phone":"XXXXXXXXXX","name":"XXXXXXXXXX","userExtension":"XXXXXXXXXX","company":null,"userDepartment":"Service","userDevice":"XXXXXXXXXX","email":"XXXXXXXXXX"},"queueName":null,"service":null,"endCauseStr":null,"status":"connecting"}}Mich würden aber nur die Werte "Name" und "status" interessieren und diese gerne in einen bzw. 2 Datenpunkte schreiben lassen.
Wie komme ich die gelieferten Werte am besten reduziert?
@darkdevil
Alternativ mit einem Alias und der passenden KonvertierungJSON.parse(val).data.caller.name JSON.parse(val).data.status -
Guten Morgen zusammen,
meine Telefonanlage kann bei Gesprächen Webhooks versenden,
somit bekomme ich zu jedem Telefonat folgende Werte geschickt:
{"id":"XXXXXXXXX","type":"call:update","time":XXXXXXXXX,"pbx":"XXXXXXXXXX","company":"XXXXXXXXX","integrationId":"XXXXXXX","data":{"trunkName":"XXXXXXXXX","queueId":null,"callee":{},"destination":"+XXXXXXXXXXX","flags":[],"endCause":null,"tags":[],"endBy":"","caller":{"role":"agent","groupId":"XXXXXXXXX","userAgent":"XXXXXXXXXXXXXXXXX","type":"local","userId":"XXXXXXX","license":"XXXXXXXXXX","groupName":"XXXXXXXXXX","phone":"XXXXXXXXXX","name":"XXXXXXXXXX","userExtension":"XXXXXXXXXX","company":null,"userDepartment":"Service","userDevice":"XXXXXXXXXX","email":"XXXXXXXXXX"},"queueName":null,"service":null,"endCauseStr":null,"status":"connecting"}}Mich würden aber nur die Werte "Name" und "status" interessieren und diese gerne in einen bzw. 2 Datenpunkte schreiben lassen.
Wie komme ich die gelieferten Werte am besten reduziert?
@darkdevil Nach Korrektur des jsons (du hast beim Xen auch 2 " gelöscht!
{"id":"XXXXXXXXX","type":"call:update","time":"XXXXXXXXX","pbx":"XXXXXXXXXX","company":"XXXXXXXXX","integrationId":"XXXXXXX","data":{"trunkName":"XXXXXXXXX","queueId":null,"callee":{},"destination":"+XXXXXXXXXXX","flags":[],"endCause":null,"tags":[],"endBy":"","caller":{"role":"agent","groupId":"XXXXXXXXX","userAgent":"XXXXXXXXXXXXXXXXX","type":"local","userId":"XXXXXXX","license":"XXXXXXXXXX","groupName":"XXXXXXXXXX","phone":"XXXXXXXXXX","name":"XXXXXXXXXX","userExtension":"XXXXXXXXXX","company":null,"userDepartment":"Service","userDevice":"XXXXXXXXXX","email":"XXXXXXXXXX"},"queueName":null,"service":null,"endCauseStr":null,"status":"connecting"}}klappt das auch

dann muss es heissen

und für den Status

-
@darkdevil
Hier die Alternative über einen Alias. Da spart man sich das Script.