question

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 asked pituach answered

SQL WhatsApp

Good day,

I would like to know how i can distribute files via WhatsApp using SSIS or SQL?
Users no longer wants email, please help i would like to get this correct

Thank You

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @IsmailCassiem-3967,

Just checking in to see if the response could help you.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @IsmailCassiem-3967,

I am not familiar with WhatsApp, your issue is related to WhatsApp, suggest you posting your issue in WhatsApp forum. People there will give you a better help.

I searched this from internet, please check if below blogs could help you. They are all third part blogs.

SEND A FILE BY WHATSAPP WITH SQL SERVER
Integrate Microsoft SQL Server and WhatsApp easy, secure and without limit


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 answered Cathyji-msft commented

Thank you these looks great, unfortunately I have no Capex to play and buy a license

Is there no other options?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @IsmailCassiem-3967,

I am not familiar with WhatsApp, then i could not do a test for your question. Suggest you posting your issue on WhatsApp forum, people there will give you a better help.


0 Votes 0 ·
pituach avatar image
0 Votes"
pituach answered

Good day,

I would probably not use the solution mentioned here using afilnet.com solution, unless you 100% sure this third party company is reliable. This solution is based on third party company solution which will need to get your permission to control your WhatsApp (phone) probably.

Their solution is simply to send HTTP request from SQL Server, which is not related to this specific solution. You send the request to their server, which then send the WhatsApp message.

So what you need is doing the same idea for step 1: sending HPPT Request using Ole Automation Procedures, sp_OACreate, sp_OAMethod

But we can send it to a service which we control - a different solution (web service), which will do the second step : send the WhatsApp messages.

So which web service can we use?

You can develop one on your server using the WhatsApp API. For more information about it, check this link:
https://developers.facebook.com/docs/whatsapp/getting-started/

note: Obviously if you cannot develop such app then you will probably need a third party solution

Note! As much as I remember, there was a request from Microsoft in the UserVoice to add a connector to WhatsApp. If they will do so, then we will be able to solve this issue in a few minutes using Azure Logic apps.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.