populate SharePoint from JSON array

[Ougesh]

Hello,

i need help for the below scenario.

i used an output variable(CNP_Extract) to get the data from PAD (which is in form of a table, fields: Received Date, Account No, Debit Date, Payer Name, PI Type, Curr, Debit Amount) to cloud flow.

After parsing the output, the JSON is like this

"CNP_Extract": "Received Date, Account No, Debit Date, Payer Name, PI Type, Curr, Debit Amount\r\n28/10/2020, 9999999999999, 28/10/2020, XX00_NOTMUR, LTP, USD, 500\r\n
i need to get the JSON into the correct array format so that i can populate the SharePoint.

[Ougesh]

@DamoBird365 

[DamoBird365]

HI @Ougesh 

Here's the basic idea.

Split on the return line \r\n and then use select to split again on the delimiter.  Then remove the last object via a filter is not equal to nothing.  You can either manually specify the key name OR use a dynamic expression by retrieving the first object of the original array.

FROM skskip(body('Filter_array'),1)

KEY split(first(outputs('Split')),',')[0]  then 1,2,3,4

VALUE split(item(),',')[0] then 1,2,3,4

The output is :

You can sort leading or trailing spaces with trim() i.e. trim(split(first(outputs('Split')),',')[0])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉