Skip json first level

(0) Share

Report

Posted on by DF-07111556-0

After http post, i get a body like this :

"body": [

"OK",

[

{

"DESCRIPCION": "XXXXXX",

"NAME": "YYYYY"

{

"DESCRIPCION": "XXXXXX",

"NAME": "YYYYY"

]

The first node reprents the status code, and i only want to iterate the items after this level.

I have tried to parse json, but return full json and if i use foreach statement and ,for example 'create item in sharepoint action' , only return the ok from first level.

The idea is to skip the first level (OK) and go through all the elements of the json creating in SP items

Thanks

Thanks

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are you sure that's the exact JSON you get? It's not valid the way it is. For it to be valid JSON you need to have key/value pairs for everything.

Was this reply helpful? Yes No
DF-07111556-0 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for your attention.
Yes i think so. After HTTP action i review the output and the result is :

{
    "statusCode": 200,
    "headers": {
        "Server": "nginx/1.18.0,(Ubuntu)",
        "Date": "Sun, 11 Dec 2022 12:30:33 GMT",
        "Transfer-Encoding": "chunked",
        "Connection": "keep-alive",
        "Cache-Control": "max-age=0",
        "Content-Type": "application/json",
        "Expires": "Sun, 11 Dec 2022 12:30:33 GMT",
        "Content-Length": "1088"
    },
    "body": [
        "OK",
        [
            {
                "DESCRIPCION": "acbdc",
                "NOMBRE.PROYECTO": "yyyy11",
                "FECHA": "2022-11-21",
                "CODIGO PROYECTO": "10205811"
            },
{
                "DESCRIPCION": "aszxfdf",
                "NOMBRE.PROYECTO": "yyyy22",
                "FECHA": "2022-11-21",
                "CODIGO PROYECTO": "10205822"
            },
        ]
    ]
}

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!
Ah, Ok. See example below where Compose contains your raw JSON and Compose 2 has the expression to extract the array of objects from the body element using the following expression.

outputs('Compose')?['body'][1]

Was this reply helpful? Yes No
DF-07111556-0 on at

Like (0)

Report
Copy link

Link copied!

Thats nice!! thank you very much 😉

Was this reply helpful? Yes No