cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GraemeMitchell
Level: Powered On

XML Data

I have a simple XML file that I would like to import into the CDS using the New Entity from Data.  I locate the XML file which is on my companies Sharepoint and it loads it and I can see 4 columns (Name, Namespace, Value and Attributes).  Below those headers I have 1 line of information, Detail, nothing in Namespace, then [Table] in Value and [Table] in Attributes.  If i click the Value [Table] link i now see the same column headers as before but I see the word data in the Name column and there are 43 lines (which is the number of employees).  If I click the [Table] in the Value column again i finally get to the data that I need, 3 bits of information showing employee Clock, Name and In-Out.

How do I choose the right primary key, it should be the Clock and all I want is those 3 pieces of data

4 REPLIES 4
Leo09
Level 8

Re: XML Data

can you share your xml file here? Or a similar XML file and remove the sensitive data.

GraemeMitchell
Level: Powered On

Re: XML Data

<?xml version="1.0" encoding="utf-8" ?> 
- <detail>
- <data>
  <Clock>101</Clock> 
  <Name>Alan H</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>149</Clock> 
  <Name>Darshan Brar</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>215</Clock> 
  <Name>Clare M</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>280</Clock> 
  <Name>Stewart B</Name> 
  <In-Out>1</In-Out> 
  </data>
- <data>
  <Clock>371</Clock> 
  <Name>Jan A</Name> 
  <In-Out>1</In-Out> 
  </data>

This is a few lines of the XML I am looking to import in CDS

GraemeMitchell
Level: Powered On

Re: XML Data

Is the XML is the correct format? 

GraemeMitchell
Level: Powered On

Re: XML Data

Is there documentation posted on how to use XML's with the import? I get to the first pic and select next and then in the next pic I am not sure what to select to correct the error.  The XML I am trying to import is in Post #3 in this thread

Pic1.pngPic2.png

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 324 members 5,611 guests
Please welcome our newest community members: