Hi, I'm trying to create a record from a webservice (using Servi

Hi,

I'm trying to create a record from a webservice (using Service backed Record). Here when i try to call the service, i get the below output for which i need to put them in CDT. Please assist me how can i proceeed.

<?xml version="1.0" encoding="UTF-8"?> <query_results> <query>SELECT col1,col2,col3,col4 FROM regulatory_document</query> <docbases> <docbase>*****</docbase> </docbases> <more_available>false</more_available> <results> <value_object class="com.fcg.dmsl.fdk.objects.ValueObjectAdapter" date_format="yyyy/MM/dd HH:mm:ss" docbase="*****" format_version="1.0" id="col1.data1" timestamp="2015/05/11 07:04:30"> <attributes> <attribute name="col1"> <value index="0">col1.data1</value> </attribute> <attribute name="col2"> <value index="0">col2.data1</value> </attribute> </attributes> </value_object> <value_object class="com.fcg.dmsl.fdk.objects.ValueObjectAdapter" date_format="yyyy/MM/dd HH:mm:ss" docbase="*****" format_version...

OriginalPostID-148565

OriginalPostID-148565

  Discussion posts and replies are publicly visible

Parents
  • ...="1.0" id="col1.data2" timestamp="2015/05/11 07:04:30"> <attributes> <attribute name="col1"> <value index="0">col1.data2</value> </attribute> <attribute name="col2"> <value index="0">col2.data2</value> </attribute> </attributes> </value_object> .....</results> </query_results>

    Performing with xpathdocument results in all the values clubbed together like (col1.data1,col2.data1,col1.data2,col2.data2,.....)
    I want to store the col1, col2 details to fields in CDT
Reply
  • ...="1.0" id="col1.data2" timestamp="2015/05/11 07:04:30"> <attributes> <attribute name="col1"> <value index="0">col1.data2</value> </attribute> <attribute name="col2"> <value index="0">col2.data2</value> </attribute> </attributes> </value_object> .....</results> </query_results>

    Performing with xpathdocument results in all the values clubbed together like (col1.data1,col2.data1,col1.data2,col2.data2,.....)
    I want to store the col1, col2 details to fields in CDT
Children
No Data