Unanswered

Parse HTTP JSON empty

(1) Share

Report

Posted on by leomarcansoni

Hello guys!

I'm receiving json data and I would like to parse it to take the image body.

Firstly I sent an HTTP request to my Sharepoint list, then I composed the body of my HTTP request to get a sample to generate my schema.

The input of my Compose is Send an HTTP request to Sharepoint Body, as below:

The schema of my Parse HTTP JSON

{
    "type": "object",
    "properties": {
        "__metadata": {
            "type": "object",
            "properties": {
                "id": {
                    "type": "string"
                },
                "uri": {
                    "type": "string"
                },
                "etag": {
                    "type": "string"
                },
                "type": {
                    "type": "string"
                }
            }
        },
        "FirstUniqueAncestorSecurableObject": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "RoleAssignments": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "AttachmentFiles": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "ContentType": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "GetDlpPolicyTip": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "FieldValuesAsHtml": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "FieldValuesAsText": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "FieldValuesForEdit": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "File": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "Folder": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "LikedByInformation": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "ParentList": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "Properties": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "Versions": {
            "type": "object",
            "properties": {
                "__deferred": {
                    "type": "object",
                    "properties": {
                        "uri": {
                            "type": "string"
                        }
                    }
                }
            }
        },
        "FileSystemObjectType": {
            "type": "integer"
        },
        "Id": {
            "type": "integer"
        },
        "ServerRedirectedEmbedUri": {},
        "ServerRedirectedEmbedUrl": {
            "type": "string"
        },
        "ContentTypeId": {
            "type": "string"
        },
        "Title": {},
        "OData__ColorTag": {},
        "ComplianceAssetId": {},
        "ID_AUDITORIA": {
            "type": "string"
        },
        "AUDITOR": {
            "type": "string"
        },
        "AUDITADO": {
            "type": "string"
        },
        "DATA": {
            "type": "string"
        },
        "TURNO": {
            "type": "string"
        },
        "PERGUNTA": {
            "type": "string"
        },
        "RESPOSTA": {
            "type": "string"
        },
        "OBSERVACAO": {
            "type": "string"
        },
        "QUESTAO": {
            "type": "integer"
        },
        "IMAGE_EVIDENCE": {
            "type": "string"
        },
        "NOTA_QUESTAO": {
            "type": "integer"
        },
        "ID": {
            "type": "integer"
        },
        "Modified": {
            "type": "string"
        },
        "Created": {
            "type": "string"
        },
        "AuthorId": {
            "type": "integer"
        },
        "EditorId": {
            "type": "integer"
        },
        "OData__UIVersionString": {
            "type": "string"
        },
        "Attachments": {
            "type": "boolean"
        },
        "GUID": {
            "type": "string"
        }
    }
}

After this, I used compose another time with the intention to copy the output of my image column (IMAGE_EVIDENCE), but when I run my flow, the output returns empty and I need your help to understand why...

Can you help me?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

You have to share the actual JSON that you received, and it should be really easy to look at that and see why its blank.

Can you share that please. the one that matches the above schema.

Was this reply helpful? Yes No

leomarcansoni on at

Like (0)

Report

Copy link

Link copied!

Hello FLMike!

Here is what i receive from 'Parse HTTP JSON' when I run my flow.

{
  "d": {
    "__metadata": {
      "id": "d68a75b7-4326-4d85-acfe-9b388e208bd9",
      "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)",
      "etag": "\"4\"",
      "type": "type text"
    },
    "FirstUniqueAncestorSecurableObject": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/FirstUniqueAncestorSecurableObject"
      }
    },
    "RoleAssignments": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/RoleAssignments"
      }
    },
    "AttachmentFiles": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/AttachmentFiles"
      }
    },
    "ContentType": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/ContentType"
      }
    },
    "GetDlpPolicyTip": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/GetDlpPolicyTip"
      }
    },
    "FieldValuesAsHtml": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/FieldValuesAsHtml"
      }
    },
    "FieldValuesAsText": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/FieldValuesAsText"
      }
    },
    "FieldValuesForEdit": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/FieldValuesForEdit"
      }
    },
    "File": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/File"
      }
    },
    "Folder": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/Folder"
      }
    },
    "LikedByInformation": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/LikedByInformation"
      }
    },
    "ParentList": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/ParentList"
      }
    },
    "Properties": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/Properties"
      }
    },
    "Versions": {
      "__deferred": {
        "uri": "https://mysharepointsite.com/sites/Prod/_api/Web/Lists(guid'b659c60d-60ca-4649-b501-fd265f161139')/Items(56)/Versions"
      }
    },
    "FileSystemObjectType": 0,
    "Id": 56,
    "ServerRedirectedEmbedUri": null,
    "ServerRedirectedEmbedUrl": "",
    "ContentTypeId": "0x0100B5EE492AADA419469AB3C3658572BAD200DB0EB4D6753AA842A884B83EBE891D85",
    "Title": null,
    "OData__ColorTag": null,
    "ComplianceAssetId": null,
    "ID_AUDITORIA": "2407241052",
    "AUDITOR": "JOHN DOE",
    "AUDITADO": "JANE DOE",
    "DATA": "2024-07-24T03:00:00Z",
    "TURNO": "TURNO 1",
    "PERGUNTA": "QUESTION",
    "RESPOSTA": "REINCIDENTE",
    "OBSERVACAO": "OBS",
    "QUESTAO": 6,
    "IMAGE_EVIDENCE": "{\"fileName\":\"Reserved_ImageAttachment_[14]_[IMAGE_EVIDENCE][36]_[0139220c-6f88-46ee-a434-6c8394e4ffe1][1]_[1].jpeg\"}",
    "NOTA_QUESTAO": 0,
    "ID": 56,
    "Modified": "2024-07-25T17:34:55Z",
    "Created": "2024-07-24T14:03:34Z",
    "AuthorId": 487,
    "EditorId": 206,
    "OData__UIVersionString": "4.0",
    "Attachments": true,
    "GUID": "id"
  }
}