What would be the structure of the temp-table ?

Posted by jmls on 25-Feb-2010 13:57

I am bashing my head against the brick wall here.

If I have this xml :

<?xml version='1.0' encoding='UTF-8'?>

        <entry xmlns='http://www.w3.org/2005/Atom' xmlns:apps='http://schemas.google.com/apps/2006' xmlns:gd='http://schemas.google.com/g/2005'>

                <id>https://apps-apis.google.com/a/feeds/dotr.com/user/2.0/julian</id>

                <updated>1970-01-01T00:00:00.000Z</updated>

                <category scheme='http://schemas.google.com/g/2005#kind' term='http://schemas.google.com/apps/2006#user'/>

                <title type='text'>julian</title>

                <link rel='self' type='application/atom+xml' href='https://apps-apis.google.com/a/feeds/dotr.com/user/2.0/julian'/>

                <link rel='edit' type='application/atom+xml' href='https://apps-apis.google.com/a/feeds/dotr.com/user/2.0/julian'/>

                <apps:login userName='julian' suspended='false' ipWhitelisted='false' admin='true' changePasswordAtNextLogin='false' agreedToTerms='true'/>

                <apps:quota limit='25600'/><apps:name familyName='Lyndon-Smith' givenName='Julian'/><gd:feedLink rel='http://schemas.google.com/apps/2006#user.nicknames' href='https://apps-apis.google.com/a/feeds/dotr.com/nickname/2.0?username=julian'/>

                <gd:feedLink rel='http://schemas.google.com/apps/2006#user.emailLists' href='https://apps-apis.google.com/a/feeds/dotr.com/emailList/2.0?recipient=julian%40dotr.com'/>

       </entry>

What temp-tables would I need ? I can't seem to create dynamic datasets (entry is a keyword), and can't get anywhere

Help save a Lyndon-Smith today !

All Replies

Posted by Peter Judge on 25-Feb-2010 14:07

I had to add another entry node outside the entry node (but I suspect that you just send a fragment).

-- peter

Posted by jmls on 25-Feb-2010 14:11

Sorry, you've lost me there. And no, there is no other nodes. This is the complete file , straight from Google !

Posted by Thomas Mercer-Hursh on 25-Feb-2010 14:13

I am bashing my head against the brick wall here

I've not found that a particularly useful debugging tool.

Do you have Stylus Studio?  If not, I recommend it for anyone who has to work with XML.  If one plugs your XML into Stylus Studio and looks at the tree view, one can see that entry has below it category, title, link, apps:login apps:quota, apps:name, and gd:feedlink, each of which has its own properties.  In the ordinary course of events, I would expect you to need a separate TT for each of those in order to represent this data structure.  I.e., it is a PDS, not a TT.

Posted by Peter Judge on 25-Feb-2010 14:27

Sorry, you've lost me there. And no, there is no other nodes. This is

the complete file , straight from Google !

No, mea culpa. I was trying to point out was that the ABL allows you to map node and attribute names (that are keywords or just different to your internal schema) to ProDataSet, temp-table and field names via the XML-NODE-NAME and XML-NODE-TYPE keywords. This helps with static temp-tables. For dynamic temp-tables, you'll need an XSD file which contains those mappings via the prodata:fieldname attribute in the XSD.

As TMH says, tools are your friend for clarifying what's in the XML.

-- peter

This thread is closed