I want to get all Constituents from CRM where UpdatedDateTime is > "Some date time". I look at the GET methods CRM/Constituents/Search?... with all parameters ...i looked at "atype" where the UpdatedDateTime is not specified. How do i specify the search?
Hi Anandhan,
There is not a way to search for constituents by UpdateDateTime or CreateDateTime out of the box.
Can you describe a little more about what you are trying to accomplish by searching for accounts as you describe? There may be another way to accomplish it.
Thanks!
Chris Szalaj
Product Owner, Business Facing Products
Tessitura Network
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
Anandhan,
For that type of operation, you will need to work with the Tessitura client to use a custom stored procedure, and the Custom/Execute endpoint of the REST services to execute that stored procedure.
/Help/Api/POST-Custom-Execute in the REST API Help pages.
Thanks, let us know if you have other questions.
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.