Hello @cody.pieper, one thing I would do is use the workflow automator and add a note to a ticket that output the values you are getting for capacity and free_space. Maybe you have already done whats necessary to validate the values you are getting from these fields, and if so could you share a screenshot of those values? This could help us troubleshoot further. If the note outputs the two numbers as strings accordingly then we at least know that we are starting with correct data before using an expression to alter those values.

TIA

Thanks Zachary!

Here’s the JSON parser node with the two values:

I’ve been sending the test data to myself as emails:

This is what I receive:
 

So it does appear that the JSON parser outputs the wrong values, hopefully I’m not mistaken!

Hello @cody.pieper, one thing I would do is use the workflow automator and add a note to a ticket that output the values you are getting for capacity and free_space. Maybe you have already done whats necessary to validate the values you are getting from these fields, and if so could you share a screenshot of those values? This could help us troubleshoot further. If the note outputs the two numbers as strings accordingly then we at least know that we are starting with correct data before using an expression to alter those values.

TIA

Thanks Zachary!

Here’s the JSON parser node with the two values:

 

 

I’ve been sending the test data to myself as emails:

 

 

This is what I receive:
 

 

 

So it does appear that the JSON parser outputs the wrong values, hopefully I’m not mistaken!

Hello, 

Have you tried to change the type in the JSON parser?

//Daniel 

Good suggestion @Daniel Söderlund. @cody.pieper, if you remove the quotations from around the two fields in the “Structured View” then generate the output again, it will change the type.

Hopefully that allows you to get the correct value.

Hey Daniel and Zachary,

Thanks for the great idea - I’ve attempted that but unfortunately, still all outputting as ‘true’ regardless of being any of strings, numbers or arrays of them.

I have a Zoom call with a Freshservice product specialist in 15 minutes - if they can find anything, I’ll report back what is going on.

Thanks again for the help so far!
Cody

The product specialist has hit gold for me, thankfully!

So instead of generating the JSON parser values with the generate button, I made the two values manually. This isn’t the issue specially, but it caused it. The issue is that in the actual automation, the parser needs the heirarchy of variables all the way up to the root object to find the values.

Oddly, the JSON parser preview section displays the values I want correctly, without the heirarchy being intact. Perhaps the backend for the preview section is newer/more resilient than the JSON parser code for automation - but that’s above my head.

This is what I’m now using in the JSON

My next challenge is to find how to get a value to output just as a number, i.e. 952 without the t“”]. In the past I have definitely had a JSON parser resolve directly into a number, but I’ve somehow lost the ability to do so with the same method (setting the type as Number and selecting the first element in the array of data).

I’ve also tried to set it as an Array of Numbers (containing only “952” and then select the first element.

Either through the JSON parser itself - $.components

Good suggestion @Daniel Söderlund. @cody.pieper, if you remove the quotations from around the two fields in the “Structured View” then generate the output again, it will change the type.

Hopefully that allows you to get the correct value.

That’s really interesting, and similar to what I’ve experienced in the past. I did so and noticed that it indeed changed the previews to the format number]

To test, I made an expression to divide one number by the other to get a decimal output:

But the expression still fails due to invalid operands as the values still come through in the format of t‘number’]

Will keep experimenting!

Ahh I’m a dork!

I just re-read what Zachary expanded on from what Daniel said and realised the secondary issue I just mentioned. Although unrelated to the topic issue - that the JSON parser was setting values as ‘True’, once that was resolved I still couldn’t get the values as actual numbers.

My isuse was I didn’t realise the the JSON output of the web request api/v2/assets/{{asset.display_id}}/components shows all component values as strings - hence why the parser set them as such. Usually computer data is quite data-type accurate in Freshservice, but the components module of assets is a little more nuanced, so I can understand why String is the safe bet for all data.

Example of component data (All Strings):

                    "drive_name": "C",

                    "file_type": "NTFS",

                    "capacity": "952",

                    "drive_type": "Local",

                    "free_space": "757"

Example of asset data (Strings and Numbers)
            "os_service_pack_13000168144": "0.0",

            "memory_13000168144": 15.78,

            "disk_storage_13000168144": null,

            "disk_space_13000168144": 952,

            "cpu_speed_13000168144": 1.99,

            "cpu_core_count_13000168144": 4

But that’s fine, it just means I’ll use Expression Builder to substring out the number before using it in any maths.

Thanks all!

Hey @cody.pieper glad to hear that you are able to get access to the correct values from the JSON Parser. Hopefully you are able to work with the expression node to get the correct type you need for the values in the array.

Appreciate you documenting your journey through this problem here. I am sure it will prove valuable to the community!

Take care :)