What will be a good/possible approach to do the bidirectional syncing of data (e.g. products) among salesforce intacct and avatax ? If bidirectional syning is not possible then thinking salesforce as a single point entry how can I sync salesforce data to intacct and avatax server ?

I am using streaming API to sync the Account and Contact information from salesforce to my local system. But unable to sync AccountContactRole using the stremaing API. Lokkes like AccountContactRole does not support the steaming.

How can I sync AccountContactRole object data to my local machine ?
 

FYI I need the sync details in with in every 1 min. 

 

Thanks

 

 

Hi All,

To get updates from salesforce Account, Contact and AccountContacRole objets into my local database. I have create pushTopic for Account and Contact object and recieving update messages using JAVA streaming client successfully. But when I was creating pushTopic for AccountContactRole object using following query in developer console. 

PushTopic pushTopic = new PushTopic();
pushTopic.Name = 'ACRoleTableStreaming';
pushTopic.Query = 'SELECT AccountId,ContactId,IsDeleted,IsPrimary,Role FROM AccountContactRole';
pushTopic.ApiVersion = 30.0;
pushTopic.NotifyForOperationCreate = true;
pushTopic.NotifyForOperationUpdate = true;
pushTopic.NotifyForOperationUndelete = true;
pushTopic.NotifyForOperationDelete = true;
pushTopic.NotifyForFields = 'Referenced';
insert pushTopic;

I am getting following Error message.

12:59:29:065 EXCEPTION_THROWN [10]|System.DmlException: Insert failed. First exception on row 0; first error: INVALID_FIELD, 'AccountContactRole' is not supported: [Query]

FYI I have also tries creating above pushTopic using https://workbench.developerforce.com. Still gote same Error.

Can anyone please tell me how can I ceate pushTopic for AccountContaactRole object or how can I get real time updates from this object into my local databse using salesforce Streaming Client or any other method ?