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
can you share your xml file here? Or a similar XML file and remove the sensitive 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 the XML is the correct format?
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
User | Count |
---|---|
124 | |
87 | |
86 | |
75 | |
69 |
User | Count |
---|---|
214 | |
181 | |
140 | |
96 | |
83 |