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
<?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
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
This will be a conference that you do not want to miss!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021