Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2009-03-26T21:47:05Z by SystemAdmin
SystemAdmin
SystemAdmin
100 Posts
ACCEPTED ANSWER

Pinned topic Bulk querying RightNow

‏2009-03-26T20:59:40Z |

CustomWare is scoping a potential project for RightNow integration to a data warehouse.  One of the high-level requirements is to perform bulk querying of RightNow, e.g. bring down all contacts that have changed in the last 24 hours.  Does anyone have an example of projects where this has been implemented, or best practices on how to do it (i.e. which RightNow connector activity works most efficiently?)  Thanks!-Matt 
Updated on 2009-03-26T21:47:05Z at 2009-03-26T21:47:05Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    100 Posts
    ACCEPTED ANSWER

    RightNow queries

    ‏2009-03-26T21:31:08Z  in response to SystemAdmin
    You need to create a view in RightNow that you then reference in the search API. We have examples for contacts and opportunities.

    RightNow limits the search response to 10000 results, so you will need to implement a while loop, then make sure the data is sorted by date ascending, and take the most recent date and pass it back into the search API after each iteration. When the response is 0 rows, you have exhausted the data set. 

    I will create a separate thread with an example report you can import to RightNow, and link it back here.
     Alan
  • SystemAdmin
    SystemAdmin
    100 Posts
    ACCEPTED ANSWER

    Sample reports

    ‏2009-03-26T21:47:05Z  in response to SystemAdmin

    https://community.castiron.com/node/2299