Update fields after executing package

  • 23Views
  • Last Post 6 days ago
  • Topic Is Solved
0
votes
Sakthi Finance Ltd. posted this 2 weeks ago

Hi Team,

 

I need the information. If I run a package (Source = Salesforce.com and Destination = MySQL) and the package executed completely, can I update few fields for successfully executed records? Is Skyvia will return any value after execution?

 

Please help me with this. You can contact me through shruti.hasilkar@kvpcorp.com

 

Thanks in advance.

 

Best regards,

Shruti Hasilkar

Order By: Standard | Newest | Votes
0
votes
Dmitriy Muzurov posted this 2 weeks ago

Hi Shruti,

Thank you for submitting a ticket with us.

If the package is executed successfully, that means the rows in MySQL table are created/changed somehow.

If you wish to change these records, a new integration package should be created.

In case of any error, the error log will be available in your account. Please check this link

Generally, your question is not fully clear for us. Please provide us with more details about your scenario: where the fields are going to be updated, what is expected to receive after that.

Should you have any questions, do not hesitate to contact us back.

0
votes
Sakthi Finance Ltd. posted this 2 weeks ago

Hi Team,

 Thanks for quick reply.

The scenario is: 1) I am sending some record details from Salesforce to MySQL. Once the package executed successfully I want a flag as a response to Salesforce. So that I can update respective values in the Salesforce.

 

Regards,

Shruti Hasilkar

1
votes
Dmitriy Muzurov posted this 2 weeks ago

Dear Shruti,

Thank you for details.

If we understand you correctly, you need to set up a boolean flag for successfully processed records after a package run. We can offer you the following solution.

You need to set up two import packages: one from Salesforce to MySQL with INSERT operation and another one from MySQL to Salesforce with UPDATE operation.

In MySQL table you need to create an additional ID column that will store Salesforce IDs, for example, SF_ID, and a column that stores the date of record creation, for example, createdDate.

In the first package, createdDate column should be mapped with this expression: GETUTCDATE()

This will insert actual date of record creation each time a package runs. An expression mapping can be use for that.

More details about it here.

SF_ID should be mapped to standard Salesforce ID column.

Second package from MySQL to Salesforce should have a filter createdDate >= LAST_RUN.

More details about filters you can find at this link.

SF_ID should be mapped to the same Salesforce ID column.

A column that stores flags should be mapped with a constant "true".

More details about constant mapping here.

Please note that the second package will be used for updating flags only. No other fields should be mapped there.

The time difference in schedule for packages should be around 20 minutes. Suppose the first package runs at 12:00 once an hour, then the second package should be set to run at 12:20 once an hour.

For set up such schedule, you need first click "Set time restrictions"

And then set these options.

This way all records that are moved to MySQL in the first package, will be flagged as true by second package.

Should you have any questions, do not hesitate to contact us back.

  • Supported by
  • Sakthi Finance Ltd.
0
votes
Sakthi Finance Ltd. posted this 2 weeks ago

Thanks Team.

 

But instead of creating two packages like SFDC to MySQL and MySQL to SFDC, can we do it in a single package? If yes please let me know the steps. 

 

Regards,

Shruti Hasilkar.

1
votes
Dmitriy Muzurov posted this 2 weeks ago

Hi Shruti,

Thank you for getting back to us.

It is not possible to implement your scenario in a single package, since a schedule is set up for the whole package and all tasks, that this package includes, will be executed according to the schedule.

Two packages are required because a second package works on its own schedule and flags processed records.

Should you have any questions, do not hesitate to contact us back.

  • Supported by
  • Sakthi Finance Ltd.
0
votes
Sakthi Finance Ltd. posted this 2 weeks ago

Thank you so much team. I got the explanation. You can close this ticket. 

 

Thanks for supporting us. Have a good day!

 

Regards,

Shruti Hasilkar

0
votes
Dmitriy Muzurov posted this 2 weeks ago

Dear Shruti,

You are very welcome.

Feel free to contact us, should you have any other questions.

0
votes
Sakthi Finance Ltd. posted this 6 days ago

Hi Team,

 

Thanks for your concern. I don't have any other question. Please close the ticket. I am unable to see the "Close Ticket" option here. Please, you can close this ticket.

 

Thanks & Regards,

Shruti Hasilkar.

Close