Trying to access json data

[JohnOReilly34]

Hi, 

I created the following parse json part in my flow: 

{
    "type": "object",
    "properties": {
        "contacts": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "addedAt": {
                        "type": "integer"
                    },
                    "vid": {
                        "type": "integer"
                    },
                    "canonical-vid": {
                        "type": "integer"
                    },
                    "merged-vids": {
                        "type": "array"
                    },
                    "portal-id": {
                        "type": "integer"
                    },
                    "is-contact": {
                        "type": "boolean"
                    },
                    "profile-token": {
                        "type": "string"
                    },
                    "profile-url": {
                        "type": "string"
                    },
                    "properties": {
                        "type": "object",
                        "properties": {
                            "firstname": {
                                "type": "object",
                                "properties": {
                                    "value": {
                                        "type": "string"
                                    }
                                }
                            },
                            "lastmodifieddate": {
                                "type": "object",
                                "properties": {
                                    "value": {
                                        "type": "string"
                                    }
                                }
                            },
                            "company": {
                                "type": "object",
                                "properties": {
                                    "value": {
                                        "type": "string"
                                    }
                                }
                            },
                            "lastname": {
                                "type": "object",
                                "properties": {
                                    "value": {
                                        "type": "string"
                                    }
                                }
                            }
                        }
                    },
                    "form-submissions": {
                        "type": "array"
                    },
                    "identity-profiles": {
                        "type": "array",
                        "items": {
                            "type": "object",
                            "properties": {
                                "vid": {
                                    "type": "integer"
                                },
                                "saved-at-timestamp": {
                                    "type": "integer"
                                },
                                "deleted-changed-timestamp": {
                                    "type": "integer"
                                },
                                "identities": {
                                    "type": "array",
                                    "items": {
                                        "type": "object",
                                        "properties": {
                                            "type": {
                                                "type": "string"
                                            },
                                            "value": {
                                                "type": "string"
                                            },
                                            "timestamp": {
                                                "type": "integer"
                                            }
                                        },
                                        "required": [
                                            "type",
                                            "value",
                                            "timestamp"
                                        ]
                                    }
                                }
                            },
                            "required": [
                                "vid",
                                "saved-at-timestamp",
                                "deleted-changed-timestamp",
                                "identities"
                            ]
                        }
                    },
                    "merge-audits": {
                        "type": "array"
                    }
                },
                "required": [
                    "addedAt",
                    "vid",
                    "canonical-vid",
                    "merged-vids",
                    "portal-id",
                    "is-contact",
                    "profile-token",
                    "profile-url",
                    "properties",
                    "form-submissions",
                    "identity-profiles",
                    "merge-audits"
                ]
            }
        },
        "has-more": {
            "type": "boolean"
        },
        "vid-offset": {
            "type": "integer"
        }
    }
}

I want to take the first name, lastname and email address but unfortunately in the dynamic content in the next step i don't really the fields I need to (see below):

Any tips please?

[v-alzhan-msft]

Hi @JohnOReilly34 ,

You could refer to screenshot below to create the flow:

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JohnOReilly34]

Thank you. That works well for lastname and firstname. I'm also trying to get the email address. I don't seem to be able to find this from the dynamic content though. 

[v-alzhan-msft]

Hi @JohnOReilly34 ,

Please check from your data and there is no email address property could be found.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JohnOReilly34]

hi Alice, 

This is the result of the GET http step. 

{
      "addedAt": 1526301893029,
      "vid": 84527,
      "canonical-vid": 84527,
      "merged-vids": [],
      "portal-id": 4489239,
      "is-contact": true,
      "profile-token": "AO_T-mPfLPg8Ln1JeMCVfKtBNWLLiaIkQxjT5NIIaXCVIO2UgYBu9dwkRICdzKsI6zwhM3GToSze1kGawQj-bQiU6nmVV-PoOO-6VPZpWshJtajX4dWA6qx0yZBJ1e4GY6K4JBgpiSCl",
      "profile-url": "https://app.blah.com/contacts/4489239/contact/84527",
      "properties": {
        "firstname": {
          "value": "John"
        },
        "lastmodifieddate": {
          "value": "1549271472332"
        },
        "lastname": {
          "value": "Doe"
        }
      },
      "form-submissions": [],
      "identity-profiles": [
        {
          "vid": 84527,
          "saved-at-timestamp": 1526301892907,
          "deleted-changed-timestamp": 0,
          "identities": [
            {
              "type": "EMAIL",
              "value": "John.Doe@company.com",
              "timestamp": 1526301797245,
              "is-primary": true
            },
            {
              "type": "LEAD_GUID",
              "value": "4744e347-8ca5-4922-b803-6b1a3e2d0654",
              "timestamp": 1526301892907
            }
          ]
        }
      ],
      "merge-audits": []
    }
  ],
  "has-more": true,
  "vid-offset": 84527
}

There is an email address found in the step, I'm just wondering how I can access this in the flow. Thanks again for your help.  

[v-alzhan-msft]

Hi @JohnOReilly34 ,

I'm afraid that there is no any way to get the value of the EMAIL in your scenes in Microsoft flow currently.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.