CRM On Demand - Web Services Integration (MOSC)

MOSC Banner

Efficient querying of Child Elements?

edited Jun 29, 2012 12:46PM in CRM On Demand - Web Services Integration (MOSC) 1 commentAnswered
We are trying to implement an inhouse backup of our CRMoD data and cannot find a way to effectively query for Modified Child elements - such as Contact/Account Addresses, and can find no documentation on this.

With Contacts for example, trying to get daily deltas of modified addresses by (in effect) looping through a million Contacts is surely not the way to go?

There is an inconsistancy (in our implementation) of what happens to the Parent Object <modifiedDate> element when the Address is modified. Where the Address is embedded in the Parent Object, and it is updated by editing that Parent object, then the Parent Object Modifed tag is updated. Where it is not edited from within the Parent Object (even if embedded) or where additional addresses (not in the Parent Object) are modified, then the Parent object <modifiedDate> tag is not updated.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center