Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Common Data Service - List Records - Bad JSON on expand?

Hello Flow Community,


I'm using the Common Data Service List Records step to pull some data out of an entity including some properties from a related entity using the expand box. The problem I seem to be having is that the JSON that is returned seems to be badly formatted for the related properties.


This is end of the first record that is returned:

      "hs_prescriptionmedication": false,
      "hs_MainContact": "{\r\n  \"address1_postalcode\": \"NW10 6BA\",\r\n  \"contactid\": \"07859a78-5d8a-ea11-a811-000d3a654e39\"\r\n}"

 hs_prescriptionmedication is a property of the main entity and hs_MainContact is the related properties. Rather than being returned as more nested JSON items the related properties are being returned as the JSON as a string with the whole item quoted, \r\n printed explicitly and the internal quotes escaped. This means I can't use the Parse JSON step to pull out the related properties because rather than the nicely nested JSON they are this odd string instead. In examples such as this one the related properties come as properly formatted JSON.

Is there something I need to do to get the related properties in properly formatted JSON?

Any help gratefully received!


Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,660)