Hey @JoeSvoboda
Got it. Here you go:
Explaining the steps:
1. Initialize a variable with your string to be able to parse it.
2. Replace all null records by "". This is important because you'll want to create a JSON, and it will fail if there are null values. The formula is simple:
replace(variables('TEST'),'null','""')
3. Get the JSON. Press "Generate from Sample" and paste your string to generate the structure. If it fails here's the correct one:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"value": {
"type": "string"
}
},
"required": [
"name",
"value"
]
}
}
4. Create a variable to get your desired array
5. Concatenate the values and add them to the array created before.
In this step you can use also the "concat() function" to get exactly the combination of " and ":" that you want.
The result will be something like this:
[
"Account Manager:Joe Svoboda",
"AutoTask Workplace:",
"Backup Solution:Datto",
"Billing POC:"
]
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
