Re: [EXTERNAL] Re: send text msg to phone from IBM i

Rob thanks for this example...

I'm trying to duplicate the below qsys2.get_clob with a
systools.httpgetclob (because I'm not on the new release with the
qsys2.get_clob...

Do you know if it can be done?

Scotts qsys2.get_clob example...

values Qsys2.Http_Post(
'
https://api.twilio.com/2010-04-01/Accounts/xxxxxx/Messages.json
'
,cast(
'To=+1999999999' concat
'&From=+1999999999' concat
'&MessagingServiceSid=xxxxx'
concat
'&Body=iSee Rest Text Message Test ' as varchar(855)
)

,'{"basicAuth":"xxxxxx,999999",

"header":"content-type,application/x-www-form-urlencoded"}'
);



My attempted version with systools.httpgetclob...

values systools.httppostclob('
https://api.twilio.com/2010-04-01/Accounts/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/Messages.json
'
,cast (

'To=+xxxxxxxxxxx' concat

'&From=+xxxxxxxxxxxx' concat

'&MessagingServiceSid=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' concat
'&Body=Jays
Twillio test ' as varchar(855)
)
-- ,cast(null as clob(1k))
,'{"basicAuth":"
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ,xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",

"header":"content-type,application/x-www-form-urlencoded"}'
);

when I run this I'm getting...

sql state 38000
vendor code -4302

Message (sql4302) java stored procedure or user-defined functions
systools.httppostclob, specify name http000013 aborted with an exception
"Content is not allowed in prolog".

After reading
https://www.ibm.com/docs/en/i/7.3?topic=overview-httppostblob-httppostclob-scalar-functions
It appears to me there are 2 required parms (1st parm url and 2nd,3rd parm
header) and one optional (2nd parm XML document).

tia

Jay




On Fri, Nov 11, 2022 at 3:27 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

You can use sql to call third party API’s to send txt msgs through
services like twillio but trying to avoid third parties if possible.

Jay

On Nov 9, 2022, at 9:42 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

I had a COWorker (not my department) send me an email asking me to let

someone in the back door, who was already there.

Yeah, that didn't work in a timely fashion..,

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of

Jeff Crosby

Sent: Monday, November 7, 2022 8:57 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx

Subject: Re: [EXTERNAL] Re: send text msg to phone from IBM i

CAUTION: This email originated from outside of the organization. Do not

click links or open attachments unless you recognize the sender and know
the content is safe.

I get ~200 emails a day. At all hours. I purposely set my phone to not
alert me on emails. This keeps my marriage a happy one.

Fellow employees all know if it is an emergency during non-working hours
they need to text or call.

And I do check my emails quite frequently.

On Mon, Nov 7, 2022 at 8:52 AM Alan Shore via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Unfortunately - yes
I know of MANY people who never look at their e-mails - unless a text is
sent to them to look at their e-mails
Ridiculous

Alan Shore
Solutions Architect
IT Supply Chain Execution

[cid:image001.png@01D8F286.490D7DB0]

60 Orville Drive
Bohemia, NY 11716
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx

'If you're going through hell, keep going.'
Winston Churchill

From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Brad Stone
Sent: Monday, November 7, 2022 8:47 AM
To: Midrange Systems Technical Discussion <

midrange-l@xxxxxxxxxxxxxxxxxx>

Subject: [EXTERNAL] Re: send text msg to phone from IBM i

You know, here's my question about this.

Everyone has smart phones now. What's the difference between getting an
alert for a text or an email? Do people just ignore email alerts?

On Mon, Nov 7, 2022 at 7:25 AM Rolf Schillinger <
rolf.schillinger@xxxxxxxxx<mailto:rolf.schillinger@xxxxxxxxx>>
wrote:

Hi Jay,
I, too, think that the Web API route is the best. But when I last sent

SMS

without a web api, I used a cellphone connected to USB that worked

like a

standard Hayes Modem. It was just a matter of connection to it via the
USB/serial port and sending 2 or three AT commands, I think one of them

was

AT+CMGS. There's also real GSM modems that connect via serial or usb

and

they're still to be bought and in use for embedded systems stuff.
Still, save yourself the hassle and go the web api route, don't forget:
it's very hard to make your text sending redundant with your own
infrastructure.
Best regards, RS

On Mon, Nov 7, 2022 at 12:30 AM Jay Vaughn <jeffersonvaughn@xxxxxxxxx

<mailto:jeffersonvaughn@xxxxxxxxx>>

wrote:

I know you can send a txt msg with the SNDSMTPEMM command if you know

the

phone number's carrier...

Aside from calling a 3rd party web api, is there a way to send text
messages from the IBM i to a phone number if you don't know the

carrier?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:

MIDRANGE-L@xxxxxxxxxxxxxxxxxx>

To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l<

https://lists.midrange.com/mailman/listinfo/midrange-l>

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:

MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>

Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l<

https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:

support@xxxxxxxxxxxxxxxxxxxx> for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com<https://amazon.midrange.com>

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l<
https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l<
https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com<https://amazon.midrange.com>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--


*Jeff Crosby*
Senior Vice President
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
direct.dilgardfoods.com

The opinions expressed are my own and not necessarily the opinion of my
company. Unless I say so.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: https://amazon.midrange.com