Share via

SQL WhatsApp

Ismail Cassiem 226 Reputation points
2021-08-24T13:42:41.74+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,848 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-08-25T06:45:50.397+00:00

    Hi @Ismail Cassiem ,

    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.

    1 person found this answer helpful.
    0 comments
  2. Ismail Cassiem 226 Reputation points
    2021-08-26T16:39:03.76+00:00

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

    Is there no other options?

    1 person found this answer helpful.
  3. Ronen Ariely 15,096 Reputation points
    2021-08-27T02:06:36.927+00:00

    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.

    1 person found this answer helpful.
    0 comments