Answered

Turn a String into Dynamic JSON Objects

(0) Share

Report

Posted on by DennisRamirez

Hello. I have a long and awkward string that I would like turned into JSON objects that can be selected as dynamic data later on in my flow. Here's the string:

"Sharepoint Link: https://FF.sharepoint.com/:f:/s/PDRRTeam\nRequestor: Benjamin Grimm\nRequestor Email: Benjamin.Grimm@FF.com\nRequested on: 6/8/2023 2:28:51 PM\n\nNAVIGATE TO SHAREPOINT FOLDER ABOVE TO ACCESS THE ASSOCIATED COLLATERAL\n\nBasic Request Details-\nMarket: LI - CT\nService Line: Capital Markets\nOpportunity #: 12345\nLead Broker Name: Ben Grimm \nDeliverable: Flyer\nFormat: \nClient / Property / Project Name: 211 Madison Ave\nDue Date: 2023-06-30\nEvent Date: \nType of Deliverable Requested: \nNew or Existing Deliverable: New Request\nRequested Deliverable Details (Instructions, Updates, Descriptions): Test market with a dash"

I would like it turned into something similar to the following:

{

"SharepointLink": "https://FF.sharepoint.com/:f:/s/PDRRTeam",
"Requestor": "Benjamin Grimm",
"RequestorEmail": "Benjamin.Grimm@FF.com",
"RequestedOn": "6/8/2023 2:28:51 PM",

"Market": "LI - CT",
"ServiceLine:" "Capital Markets",
"Opportunity": "12345",
"LeadBrokerName": "Ben Grimm",
"Deliverable": "Flyer",
"Format": "Client / Property / Project Name: 211 Madison Ave",
"DueDate": "2023-06-30",
"EventDate": "",
"TypeofDeliverableRequested": ""
"NeworExistingDeliverable": "New Request",
"RequestedDeliverableDetails": "Test market with a dash"

}

Can anyone show me a dynamic way to process this conversion? I will be receiving many strings of this type in the future. The main categories will remain the same, but the details will be different each time. Any assistance is appreciated.

Thank you,

Dennis

Categories:

General topics

All responses (2)

Answers (1)

Sort by

Verified answer

takolota1 4,980 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Make a Compose & in the box hit the enter key so you get one linebreak.

Create another Compose & use the expression

Split(InsertPre-JSONdynamicContentHere, outputs(‘Compose’))

That should make an array with each line.

Then create another Compose with…

{
@First(Split(outputs(‘Compose_2’)[0], ‘:’)): Join(Skip(Split(outputs(‘Compose_2’)[0], ‘:’), 1), ‘’),

@First(Split(outputs(‘Compose_2’)[1], ‘:’)): Join(Skip(Split(outputs(‘Compose_2’)[1], ‘:’), 1), ‘’),

@First(Split(outputs(‘Compose_2’)[2], ‘:’)): Join(Skip(Split(outputs(‘Compose_2’)[2], ‘:’), 1), ‘’),

@First(Split(outputs(‘Compose_2’)[3], ‘:’)): Join(Skip(Split(outputs(‘Compose_2’)[3], ‘:’), 1), ‘’),

... etc for each of your 15 lines, just changing the array index [#] for each line

}
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Here is a sample I have put together.

Things for you to do:

1) Get rid of the New lines

2) Store the UTL and Dates in a variable before using the expressions (because they contain 🙂

3) Restore the values back from variables after the JSON has been formed.

JSONFormat_202306...