Heroku not syncing with SalesForce when I change values in postegres trigger
up vote
1
down vote
favorite
I am using heroku connect to sync My data with salesforce.
I need to change a field in a column after the data is synced.
SO I created a trigger after insert in postegressql that will change that column value. The problem is that when I change the value in the trigger, Heroku is not considering that a change has happened so the data is not synced.
to clarify I have an object in sales force with column name isInsertedInHeroku. By default it is false. in the postegres after insert I am changing it to true but this value is not changing in salesforce, any idea?
this is my trigger.
Please note that I already added the externalId field and when I manually update the value with an update query it will change. this is not working only when I change thru trigger.
BEGIN
UPDATE salesforce.notification__c
set isInsertedInHeroku= true
where sfid = new.sfid;
Return new;
end;
postgresql heroku salesforce
asked Nov 19 at 13:11
chahid khalil
149
add a comment |
up vote
1
down vote
favorite
I am using heroku connect to sync My data with salesforce.
I need to change a field in a column after the data is synced.
SO I created a trigger after insert in postegressql that will change that column value. The problem is that when I change the value in the trigger, Heroku is not considering that a change has happened so the data is not synced.
to clarify I have an object in sales force with column name isInsertedInHeroku. By default it is false. in the postegres after insert I am changing it to true but this value is not changing in salesforce, any idea?
this is my trigger.
Please note that I already added the externalId field and when I manually update the value with an update query it will change. this is not working only when I change thru trigger.
BEGIN
UPDATE salesforce.notification__c
set isInsertedInHeroku= true
where sfid = new.sfid;
Return new;
end;
postgresql heroku salesforce
asked Nov 19 at 13:11
chahid khalil
149
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I am using heroku connect to sync My data with salesforce.
I need to change a field in a column after the data is synced.
SO I created a trigger after insert in postegressql that will change that column value. The problem is that when I change the value in the trigger, Heroku is not considering that a change has happened so the data is not synced.
to clarify I have an object in sales force with column name isInsertedInHeroku. By default it is false. in the postegres after insert I am changing it to true but this value is not changing in salesforce, any idea?
this is my trigger.
Please note that I already added the externalId field and when I manually update the value with an update query it will change. this is not working only when I change thru trigger.
BEGIN
UPDATE salesforce.notification__c
set isInsertedInHeroku= true
where sfid = new.sfid;
Return new;
end;
postgresql heroku salesforce
asked Nov 19 at 13:11
chahid khalil
149
I am using heroku connect to sync My data with salesforce.
I need to change a field in a column after the data is synced.
SO I created a trigger after insert in postegressql that will change that column value. The problem is that when I change the value in the trigger, Heroku is not considering that a change has happened so the data is not synced.
to clarify I have an object in sales force with column name isInsertedInHeroku. By default it is false. in the postegres after insert I am changing it to true but this value is not changing in salesforce, any idea?
this is my trigger.
Please note that I already added the externalId field and when I manually update the value with an update query it will change. this is not working only when I change thru trigger.
BEGIN
UPDATE salesforce.notification__c
set isInsertedInHeroku= true
where sfid = new.sfid;
Return new;
end;
postgresql heroku salesforce
postgresql heroku salesforce
asked Nov 19 at 13:11
chahid khalil
149
asked Nov 19 at 13:11
chahid khalil
149
asked Nov 19 at 13:11
chahid khalil
149
asked Nov 19 at 13:11
chahid khalil
149
asked Nov 19 at 13:11
chahid khalil
149
149
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53375401%2fheroku-not-syncing-with-salesforce-when-i-change-values-in-postegres-trigger%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
