Visit Freshworks.com Visit Freshworks

Replies posted by Brendan_08

6 Replies

J
Apprentice
jkampmanApprentice
asked in Automations

JSON Parser - Invaid JSON Payload

This is the actual response I get from Okta: [{"id":"redacted","status":"ACTIVE","created":"2022-08-02T23:24:32.000Z","activated":null,"statusChanged":"2022-08-02T23:28:19.000Z","lastLogin":"2023-03-17T17:11:38.000Z","lastUpdated":"2022-08-02T23:28:19.000Z","passwordChanged":"2022-08-02T23:28:19.000Z","type":{"id":"redacted"},"profile":{"firstName":"redacted","lastName":"redacted","mobilePhone":null,"secondEmail":null,"login":"redacted@redacted.com","email":"redacted@redacted.com"},"credentials":{"password":{},"provider":{"type":"OKTA","name":"OKTA"}},"_links":{"self":{"href":"https://redacted.okta.com/api/v1/users/redacted"}}}] So that Is what I was trying to get piped into a condition node, and this is the error I am getting, retrieved from the Execution Logs: System Message [missing "en.js_translations.execution_logs.webrequest.response_body_new" translation] [{"id":"redacted","status":"ACTIVE","created":"2022-08-02T23:24:32.000Z","activated":null,"statusChanged":"2022-08-02T23:28

10
B
Community Debut
1 year ago
J
Apprentice
jkampmanApprentice
asked in Automations

JSON Parser - Invaid JSON Payload

Yeah, I have a ticket open with support, but they said:“Hi Brendan,I think the product team needs to consider this use case and build this natively so that it takes an array into consideration and does not throw an error.I will keep you posted with more updates on this. Thanks! “ So I’m not sure they will be much help.

10
B
Community Debut
1 year ago
J
Apprentice
jkampmanApprentice
asked in Automations

JSON Parser - Invaid JSON Payload

@Ammar KB like this:   

10
B
Community Debut
1 year ago
J
Apprentice
jkampmanApprentice
asked in Automations

JSON Parser - Invaid JSON Payload

@Ammar KB sorry forgot to tag you!

10
B
Community Debut
1 year ago
J
Apprentice
jkampmanApprentice
asked in Automations

JSON Parser - Invaid JSON Payload

Also, where am I placing ‘$.[0][0].email’ in the web request, expression builder or in the JSON Parser somewhere?

10
B
Community Debut
1 year ago
J
Apprentice
jkampmanApprentice
asked in Automations

JSON Parser - Invaid JSON Payload

stike that reading the above, I’m an idiot. Ammar, would this work for grabbing an email from the quoted array:$.[0][0].email [{"id":"redacted","status":"ACTIVE","created":"2022-08-02T23:24:32.000Z","activated":null,"statusChanged":"2022-08-02T23:28:19.000Z","lastLogin":"2023-03-17T17:11:38.000Z","lastUpdated":"2022-08-02T23:28:19.000Z","passwordChanged":"2022-08-02T23:28:19.000Z","type":{"id":"redacted"},"profile":{"firstName":"redacted","lastName":"redacted","mobilePhone":null,"secondEmail":null,"login":"redacted@redacted.com","email":"redacted@redacted.com"},"credentials":{"password":{},"provider":{"type":"OKTA","name":"OKTA"}},"_links":{"self":{"href":"https://redacted.okta.com/api/v1/users/redacted"}}}] 

10
B
Community Debut
1 year ago

Badge winners

Show all badges
Terms of UseCookie settings