Hello,
I am having a very tough time figuring out how to work with objects I get from Atlassian's API. Because their objects have so many custom fields, they don't use simple key-value pairs.
As an example, the object within the Values array here represents a specific laptop asset. Within the Attributes array in that object, the laptop's attributes are listed. However I cannot identify attributes programmatically using the attribute names... or even IDs... because of the formatting.
In order to get the "UDID" attribute value for this laptop, I need to find the object within the Attributes array where "Object type attribute ID" = 325. When I find that object, I need to look to the "Object attribute values" array within the object... look at the first object within that array, and use the value associated with the "Value" key.
How on earth can I make this work with Workato? Atlassian has made this SO complicated.
1 ACCEPTED SOLUTION
Hallelujah!!! Made a few changes to process the larger object containing both arrays... first define the ugly object using IDs but simplifying the ID-Name relationship. Then go back through that object and replace the IDs with names using the 2nd array.
Thank you @gary1 for the code that got me started!!
## provide the findIdentifiers array as your "data" input and grab it
inputObject = input["data"]
attributesArray = inputObject["values"][0]["attributes"]
definitionsArray = inputObject["objectTypeAttributes"]
new_object= {}
## loop through findIdentifiers
attributesArray.each { | a |
new_object[a["objectTypeAttributeId"]] = a["objectAttributeValues"][0]["displayValue"]
}
## loop through findIdentifiers
definitionsArray.each { | a |
## dig up the type value; this assumes only one object in the Type array
typeId = a["id"]
if new_object.has_key?(typeId)
# Rename "old_key" to "new_key"
new_key = a["name"]
old_key_value = new_object.delete(typeId)
new_object[new_key] = old_key_value
end
}
## create the output object with itemsToKeep as the value
{result: new_object}
Hey @runelynx , could you share the raw JSON response using the "Copy Raw JSON" button?
If the response has a fixed schema, it shouldn’t be difficult to retrieve the specific field you need without using Ruby code.
