{"id":316,"date":"2018-07-24T19:29:00","date_gmt":"2018-07-25T01:29:00","guid":{"rendered":"http:\/\/draith.com\/?p=316"},"modified":"2018-07-24T19:29:00","modified_gmt":"2018-07-25T01:29:00","slug":"logic-apps-or-flow-string-to-array","status":"publish","type":"post","link":"https:\/\/draith.com\/?p=316","title":{"rendered":"Logic Apps or Flow – String to Array"},"content":{"rendered":"

Ran across an interesting problem today – how to, in Flow or Logic Apps, take a string and create a data array from it. In this particular instance, the bit of data was being emailed to an Outlook.com inbox, and we wanted to parse that data and only work with 3 pieces of the string. It sounds easy, as actually is, but takes a small bit of knowledge ahead of time. Hopefully this helps you avoid some web-searches.<\/p>\n

So let’s say we have some data formatted like this:<\/p>\n

[\"f8c8e13b-48be-4a91-818e-c6fasdfd001\",\"OM.DEMO\",\"Processor\",\"% Processor Time\",\"1\",45.9060745239258,\"2018-07-17T19:46:55.577Z\",\"OpsManager12\",\"\\\\\\\\OM.DEMO\\\\Processor(1)\\\\% Processor Time\",\"d88f095c-8bf8-4e88-d827-663fe6asdf01\",null,null,null,null,null,null,\"Perf\"]<\/pre>\n
This data is a sample performance metric – something you might receive from Log Analytics, for example.  This data is obviously an array in theory, but right now it’s just a long string to Flow or Logic Apps.  So, let’s get this into a usable array and access only the bits we want.<\/p>\n
Here is the email:<\/p>\n
\"\"<\/p>\n
Now, let’s create a trigger and add a “Compose” action.  There is literally no configuration to the “Compose” action.<\/p>\n
\"\"<\/p>\n
Next, initialize a variable and set it’s type to an Array.  Set the value to the output of the “Compose” action.<\/p>\n
\"\"<\/p>\n
From here, you can call the individual instances of the array in a very straight forward method.  You simple reference the index of the item you want like this:  variables(‘StringArray’)[1]     (This would return the second item in the array since the array numbering starts at 0).  In this example, I pull out three pieces of data, and (for no particular reason) email it back to myself.<\/p>\n
\"\"<\/p>\n
And the email:
\n\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"
Ran across an interesting problem today – how to, in Flow or Logic Apps, take a string and create a data array from it. In this particular instance, the bit of data was being emailed to an Outlook.com inbox, and we wanted to parse that data and only work with 3 pieces of the string. … Continue reading “Logic Apps or Flow – String to Array”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-316","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/posts\/316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=316"}],"version-history":[{"count":0,"href":"https:\/\/draith.com\/index.php?rest_route=\/wp\/v2\/posts\/316\/revisions"}],"wp:attachment":[{"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/draith.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}