I want to get all Constituents from CRM where UpdatedDateTime is > "Some date time".

We have an UseCase where we have to initially to get all Constituents (info like name,address,email,phone,title,company and UniqueID) from Tessitura CRM to an app. After that we have to get only the Constituents created/updated after that dateTime. We have a program which is scheduled to run every 30 minutes. Say for example I have got all contacts till today @8 PM my cutoff date is 09-dec-2010@8.00 PM. When scheduled pgm runs it pickup the data created/updated after 8 PM, next time it picks u data created/updated after 8.30 PM , etc..... What could be the best possible way to achieve this.

One other query we have contactUniqueID, using that can we open that contact from the browser front end

How are you planning to get all Constituents?  I'm not seeing anywhere in the API where you can enumerate all the Constituents.

You can’t do that through the API. As Chris suggested, you would use the custom “execute local procedure” endpoint, which you would have to build a SQL procedure to support. In the SQL proc, you can enumerate constituents with a SELECT on dbo.VS_CONSTITUENTS.

You can’t do that through the API. As Chris suggested, you would use the custom “execute local procedure” endpoint, which you would have to build a SQL procedure to support. In the SQL proc, you can enumerate constituents with a SELECT on dbo.VS_CONSTITUENTS.