topic Re: Dealing with null hash/nested objects eg Link['webView']['href'] in Workato Pros Discussion Board

Dealing with null hash/nested objects eg Link['webView']['href']

yelah — Thu, 28 Nov 2024 07:07:19 GMT

I have a api call that returns similar to the following json structure:

{ "data": [ { "itemId": "001", "links": { "self": { "href": "http://website.com/api" }, "webview": { "href": "http://website.com/item" } } }, { "itemId": "002", "links": { "self": { "href": "http://website.com/api" } } } } ] }

I would like to save the result in a list and have used the "Create List by Workato" action.
I want to capture the itemId and webView link. To capture the web view link I use the hash formula: Link['webView']['href']

which works but when for example itemId 002 does not have that webView, its null. I get a formula error.
I have read this article how-to-handle-nulls-2 which is helpful but I am not sure how to implement this with using hash notation as the examples provided where for dot functions or items that are not nested, in forumla mode.

Any help for this would be great.

Re: Dealing with null hash/nested objects eg Link['webView']['href']

gary1 — Mon, 02 Dec 2024 23:52:55 GMT

I recently had a similar issue and wasn't able to figure out a way to use the "&" operator with hash notation.

I'd probably just do this and get on with it:

webview.present? ? webview["href"] : nil

Re: Dealing with null hash/nested objects eg Link['webView']['href']

yelah — Tue, 03 Dec 2024 00:52:57 GMT

Thanks that logic works.

For anyone wanting the notation for checking parent object and returning the nested item as string:

Link['webView'].present? ? Link['webView']['href'] : nil

below works if you dont mind not getting an object back:

Link['webView'].presence