Lookup a value in one SQL table with another SQL table

[Madhav.Seelam]

I want to look up a value in one SQL table and compare it with another SQL table. If the value is found, then I want to send a message to the contact number associated with that value

 

[Preeti Paryani]

Hello @Madhav.Seelam

Can you please elaborate on the exact use case you are trying to achieve? Please try to explain the scenario as:

1. Trigger (If this happens)
2. Action (Do this)
3. Action (Do this).............

 

[Madhav.Seelam]

1 Trigger (New Row in a 1st Mysql table): Take a value(Example battery serial number) in column
2 Action: look for the battery serial number in the 2nd MySQL table and pick the contact number associated with that battery serial number
3 Action: send a message to that contact number

 

[Preeti Paryani]

Hello @Madhav.Seelam

We have created a reference workflow in your account which can fulfill your use case. Please add a test record in the SQL capture the response on the "Save and Send Test Request" button and map the details accordingly, refer to the attached screenshot to learn more about the workflow.

Workflow Name: pabbly test
Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZjMDYzMDA0M2M1MjZiNTUzYzUxM2Ei_pc

Do a few tests and let us know if it works for you.

 

[Madhav.Seelam]

Hi, I have created a similar flow with my requirements; please check and let me know if that works

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Preeti Paryani]

Hello @Madhav.Seelam

Can you please confirm if you have added a new row in the table before clicking the Save and Send Test request button?

If not please add a row and capture the response by clicking the Save and Send Test Request button.

 

[Madhav.Seelam]

Sure will add a new row, test it and let you know

 

[Madhav.Seelam]

Hi Preeti, My exact requirements are as follows.

We need to send messages(Saying reconnect your battery to Bluetooth) to customers whose updated time is more than 10 days from today's date

1 Trigger : Check for the updated time in the table for more than 10 days
2 Action: If the update time is more than 10 days, get the battery number(DeviceNames) in the MySQL(BMS Cloud DB)
3 Action: Look for that battery number in another MySQL(SQL PURE)
4 Action: fetch the contact number from MySQL(SQL PURE) and send a message

 

[Preeti Paryani]

Hello @Madhav.Seelam

Your use case seems to be feasible.

Can you please confirm the Table names of both the required tables under BMS Cloud DB and SQL PURE? Also, please provide us a device details whose update time fulfills the condition of your use case.

Please note that the trigger can't be a search event. If you want to run this workflow at a particular period you can use Schedule(Pabbly). Also, we have made a few changes in the pabbly test workflow please avoid making any changes to it.

 

[Madhav.Seelam]

Table 1 (BMS Cloud DB): DL_ThingBase
Table 2 (SQL PURE): Master_Vehicle_Inventory

Device details whose update time fulfills the condition:
1 UpdateTime Less than 10 days (Should not trigger message)
2 UpdateTime More than 10 days (Need to trigger message)

 

[Preeti Paryani]

Hello @Madhav.Seelam

Does the Battery number is in the same format in Table 2 (SQL PURE): Master_Vehicle_Inventory as it is in Table 1 (BMS Cloud DB): DL_ThingBase? Can you please provide us with the screenshot of the table2?

 

[Madhav.Seelam]

Hi Preeti

Battery numbers are unique and will be in the same format in both tables. The screenshot is attached for your reference

 

[Preeti Paryani]

Hello @Madhav.Seelam

We have created a reference workflow for you in your account and the recorded detailed video on how the workflow works please refer to it - https://www.loom.com/share/6d46ff40e99e493fb2c31fcac47ac901?sid=cb76ae16-a924-4a84-9738-ba9d9ff28976

Workflow Name - pabbly test
Workflow URL - https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZjMDYzMDA0M2M1MjZiNTUzYzUxM2Ei_pc