Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
pravinm
Contributor III
Contributor III

REST API 2 MYSQL MDM (TOS Open Studio + Community Version MDM)

Hi All, 

Please correct if I have done anything wrong in the below flow, in Log sample rows I am getting all the 10 Rows logged in console but it does not commit in database, Appreciate your help, if any additional input is required to answer this questions feel free to ask.

 

0683p000009M61h.pngJob Flow

 

 

Labels (2)
1 Solution

Accepted Solutions
pravinm
Contributor III
Contributor III
Author

Thanks for the quick reply after a looking day of r&d and permutations I figured out what mistake I made.
To resolve such issues. Which are unknown.follow these steps.
1. Enable die on error on all components.
2. Run the job. Your exception message will be displayed. In my case there where extra charecters sent so corrected the mapping in tExtractJsonFields component.
3. Executed the batch. And hurray made it.


I know it's a simple achievement but it was a great deal to me.

Thanks to the community which took time to read my question.

View solution in original post

2 Replies
Anonymous
Not applicable

Hello

Which component are you using to insert the data in your database?

 

I suggest you check the commit option.

Here is the commit with mysql

0683p000009M62Q.png

 

pravinm
Contributor III
Contributor III
Author

Thanks for the quick reply after a looking day of r&d and permutations I figured out what mistake I made.
To resolve such issues. Which are unknown.follow these steps.
1. Enable die on error on all components.
2. Run the job. Your exception message will be displayed. In my case there where extra charecters sent so corrected the mapping in tExtractJsonFields component.
3. Executed the batch. And hurray made it.


I know it's a simple achievement but it was a great deal to me.

Thanks to the community which took time to read my question.