Send SMS using Azure Communication Service from MS Access

Question

Send SMS using Azure Communication Service from MS Access

Nick Mourikis 0

Hi,

Here are my details:

Subscription ID: b2de1efb-6be3-49c9-8edc-d1790e09eacd

Directory: kronosint.com (kronosint.com)

My role: Account admin

Offer: Pay-As-You-Go

Offer ID: MS-AZR-0003P

I want to send SMS using Azure Communication Service from MS Access. Could you please direct me on how to do this?

I have searched online but I did not find anything helpful.

If the above is not possible, is it possible to do it from PHP? I am able to call other REST API from access successfully but not send SMS.

Thank you in advance.

SnehaAgrawal-MSFT 22,706 Reputation points Moderator

2023-03-29T07:20:07.5266667+00:00

@Nick Mourikis Thanks for reaching here! Could you elaborate your use case as I can see MS Access is retired.

"This feature has been retired from Microsoft 365 and SharePoint Online. We stopped creation of new Access-based web apps and Access web databases in Microsoft 365 and SharePoint Online in June, 2017 and shut down any remaining web apps and web databases by April, 2018." See here
Nick Mourikis 0 Reputation points

2023-03-30T21:28:35.08+00:00

Hi, thanks for getting back to me. Is there a way to do this via PHP? Thanks again!
jlinsey628 0 Reputation points

2023-03-30T21:49:48.88+00:00
Hi,

Based on the details you provided, you have a Pay-As-You-Go subscription with Azure Communication Services and are looking to send SMS messages from MS Access or PHP.

To send SMS messages using Azure Communication Services from MS Access or PHP, you can use the Azure Communication Services SMS API. This API allows you to send SMS messages to mobile devices using a simple REST API.

Here are the basic steps to use the Azure Communication Services SMS API:

Get an authentication token: To use the SMS API, you will need an authentication token. You can get this token by using the Azure CLI, PowerShell, or the Azure portal.

Create a message: You can create an SMS message using the JSON format. The message should include the recipient's phone number, the sender's phone number, and the message text.

Send the message: You can send the message by making a POST request to the SMS API endpoint. You will need to include the authentication token in the request header, and the message JSON in the request body.

Here are some resources that can help you get started with the Azure Communication Services SMS API:

Azure Communication Services SMS API documentation: https://docs.microsoft.com/en-us/azure/communication-services/quickstarts/sms-rest?tabs=windows&pivots=programming-language-php

PHP code sample for sending SMS messages using the Azure Communication Services SMS API: https://docs.microsoft.com/en-us/samples/azure-samples/communication-services-php-quickstarts/communication-services-sms-send/

I hope this helps you get started with sending SMS messages using Azure Communication Services!

1 answer

Your answer

SnehaAgrawal-MSFT 22,706 Reputation points Moderator

2023-03-29T07:20:07.5266667+00:00

@Nick Mourikis Thanks for reaching here! Could you elaborate your use case as I can see MS Access is retired.

"This feature has been retired from Microsoft 365 and SharePoint Online. We stopped creation of new Access-based web apps and Access web databases in Microsoft 365 and SharePoint Online in June, 2017 and shut down any remaining web apps and web databases by April, 2018." See here
Nick Mourikis 0 Reputation points

2023-03-30T21:28:35.08+00:00

Hi, thanks for getting back to me. Is there a way to do this via PHP? Thanks again!
jlinsey628 0 Reputation points

2023-03-30T21:49:48.88+00:00

Hi,

Based on the details you provided, you have a Pay-As-You-Go subscription with Azure Communication Services and are looking to send SMS messages from MS Access or PHP.

To send SMS messages using Azure Communication Services from MS Access or PHP, you can use the Azure Communication Services SMS API. This API allows you to send SMS messages to mobile devices using a simple REST API.

Here are the basic steps to use the Azure Communication Services SMS API:

Get an authentication token: To use the SMS API, you will need an authentication token. You can get this token by using the Azure CLI, PowerShell, or the Azure portal.

Create a message: You can create an SMS message using the JSON format. The message should include the recipient's phone number, the sender's phone number, and the message text.

Send the message: You can send the message by making a POST request to the SMS API endpoint. You will need to include the authentication token in the request header, and the message JSON in the request body.

Here are some resources that can help you get started with the Azure Communication Services SMS API:

Azure Communication Services SMS API documentation: https://docs.microsoft.com/en-us/azure/communication-services/quickstarts/sms-rest?tabs=windows&pivots=programming-language-php

PHP code sample for sending SMS messages using the Azure Communication Services SMS API: https://docs.microsoft.com/en-us/samples/azure-samples/communication-services-php-quickstarts/communication-services-sms-send/

I hope this helps you get started with sending SMS messages using Azure Communication Services!

Answer 1

To send SMS using Azure Communication Services from MS Access, you can use the Azure SDK for .NET to create a console application that sends SMS messages. You would then use MS Access to trigger this console application as needed.

To do this from PHP, you would need to use the Azure SDK for PHP to send SMS messages. You can use the REST API provided by Azure Communication Services to send SMS messages.

Here's some documentation that could help you get started:

Please mark my answer if it helps :-)

Share via

Send SMS using Azure Communication Service from MS Access

1 answer

Your answer