Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
2 replies
Subscribers
10 subscribers
Views
1643 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Hi, I'm trying to create a record from a webservice (using Servi
srirams761
A Score Level 2
over 10 years ago
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
0
srirams761
A Score Level 2
over 10 years ago
...="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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
akshayan
Certified Lead Developer
over 10 years ago
Use torecord() function
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel