>>>>>>Hu
>>>>>>
>>>>>>I asked a few question about loading some XML before Christmas (thanks for the replies)
>>>>>>
>>>>>>An additional question.
>>>>>>
>>>>>>The Web service I am getting codes from has a limit return size of 100 items.
>>>>>>
>>>>>>There are more than 100 items in the list so I need to make repeated calls wit an offset value to get a full list .
>>>>>>
>>>>>>My question is if I load the xml into a datatable how can I then add the subsequent xml to the same datatable.
>>>>>>
>>>>>>
>>>>>>Thanks
>>>>>
>>>>>Can you remind me as to how the XML for the initial 100 items looks ?
>>>>
>>>>HI Viv
>>>>
>>>>this is the XML model
>>>>
>>>><ListItems>
>>>> <Items>
>>>> <ListItem>
>>>> <ID>string</ID>
>>>> <Level10Code>string</Level10Code>
>>>> <Level1Code>string</Level1Code>
>>>> <Level2Code>string</Level2Code>
>>>> <Level3Code>string</Level3Code>
>>>> <Level4Code>string</Level4Code>
>>>> <Level5Code>string</Level5Code>
>>>> <Level6Code>string</Level6Code>
>>>> <Level7Code>string</Level7Code>
>>>> <Level8Code>string</Level8Code>
>>>> <Level9Code>string</Level9Code>
>>>> <ListID>string</ListID>
>>>> <Name>string</Name>
>>>> <ParentID>string</ParentID>
>>>> <URI>string</URI>
>>>> </ListItem>
>>>> </Items>
>>>> <NextPage>string</NextPage>
>>>></ListItems>
>>>>
>>>>The next page is a link to a url that will give the next page of codes.
>>>>
>>>>This is an example
>>>>
>>>>https://implementation.concursolutions.com/api/v3.0/common/listitems?offset=gWjRylmbg2Q$sgk2ntXuSl591shOT1yOaB3Q&limit=100&listId=gWqmEUETdJu1SXJIJJCo6vYtHZaYn6QPrPA"
>>>>
>>>>
>>>
>>>Link gives 'unauthorized' but am I right in assuming that the XML identical except for the actual data ?
>>
>>Yes thats right.
>
>Sorry, can you also either provide a link to the original thread (or post your current code for handling this) ?
Thanks Viv
I'm not going to have to get the whole list after all as we are going to store the ID locally.
The concur web service only allows you to update via the ID which is a guid but the only way to get the id for an item was to get the whole list. But as the id is returned when you add something I can store the id against the list item outside concur (if that all makes sense).