Trying to access json data

(0) Share

Report

Posted on by 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?

Categories:

General topics

All responses (5)

Answers (0)

Sort by

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 44 on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 44 on at

Like
a
(0)

Report
Copy link

Link copied!
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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.