Forum

HomeHomeCoreCoreGeneralGeneralJSON Query XPATH sampleJSON Query XPATH sample
Previous
 
Next
New Post
2/29/2012 12:19 AM
 

Hi,  


I have a JSON query that is returning nested data.  Does anyone have the syntax to get data embedded deeper in the result set?  I think it has something to do with the XPATH, however XML XPATH syntax does not seem to apply.  Any help would be greatly appreciated. 


Thanks!





Best regards,
Robert
New Post
2/29/2012 10:16 PM
 

Nevermind.  I figured it out.



Best regards,
Robert
New Post
3/13/2012 3:06 PM
 
Could you share your solution? I am trying to pull the times results from the following JSON and can't seem to figure out the path and or root to use. I have tried everything I could think of. { "webinarKey":5303085652037254656, "subject":"How to build an API", "description":"Write it, test it, ship it", "organizerKey":73563532324, "times": [{ "startTime":"2011-04-26T17:00:00Z", "endTime":"2011-04-26T18:00:00Z" }, { "startTime":"2011-09-09T18:25:00Z", "endTime":"2011-09-09T19:25:00Z" }] }
New Post
4/8/2012 12:31 PM
 

Hi,


Try something like this:

<JSON>
<PATH>http://www.myevonyempire.com/portals/84/jsonTestFile.txt</PATH>
<GET><QUERY></QUERY></GET>
<COLUMNS>
<ROOT></ROOT>
<COLUMN><NAME>WebinarID</NAME><XPATH>webinarKey</XPATH></COLUMN>
<COLUMN><NAME>Subject</NAME><XPATH>subject</XPATH></COLUMN>
<COLUMN><NAME>Description</NAME><XPATH>description</XPATH></COLUMN>
<COLUMN><NAME>OrganizerID</NAME><XPATH>organizerKey</XPATH></COLUMN>
<COLUMN><NAME>StartTime1</NAME><XPATH>times[0].startTime</XPATH></COLUMN>
<COLUMN><NAME>EndTime1</NAME><XPATH>times[0].endTime</XPATH></COLUMN>
<COLUMN><NAME>StartTime2</NAME><XPATH>times[1].startTime</XPATH></COLUMN>
<COLUMN><NAME>EndTime2</NAME><XPATH>times[1].endTime</XPATH></COLUMN>
</COLUMNS>
</JSON>


sample as is, no guarantees and all that.



Best regards,
Robert
New Post
4/8/2012 12:57 PM
 
Sorry, I never updated this. Yeah, Kevin helped me figure it out and its a lot like what you have rmartin.
Previous
 
Next
HomeHomeCoreCoreGeneralGeneralJSON Query XPATH sampleJSON Query XPATH sample


 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seattle, WA • info@openwebstudio.com

Bookmark & Share Bookmark and Share