OdiInvokeWebService to CRM on demand

Midnight_Man

Hi I have created a SOAP web service call using ODI's invoke web service to crm on demand but I can only retrieve 100 records maximum to any object eg Account.

Does anyone know how I can retrieve all records using a for loop or while command until we reach lastpage='true'?

so far I've experimented with the below

<quer:ListOfAccount StartRowNum="PageSize+1" pagesize="100" lastpage="true">

Thanks in Advance

ASP_007

Hi

Did you get an error ? while trying so...have you tried xml reponse file type as SOAP instead of xml ?

Regards

ASP

Midnight_Man

Hi ASP

My problem is im using Oracle ODI and I don't know how to create the loop and exit I know how it works but not sure abt implementing it

The web service call should do  a ‘While Loop’ by specifying the 'pagesize' and the 'pagenumber' as input. The ‘While Loop’ repeats until the value of 'LastPage' returned by web service call is 'true'  and setting the StartRowNum argument to PageSize+1.

thanks

rpc1

Hi, look at example of implemention loops in ODI

http://www.canburaktumer.com/blog/odi-11g-implementing-loops/

https://blogs.oracle.com/dataintegration/entry/using_variables_in_odi_creatin