× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. November 2022

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

finally got it to reach out to twilio but not sure why the 401 error... all
my twilio provided credentials are correct and in fact even works in
postman when I run with the below parms...

Here is what I have now...


values systools.httppostclob('
https://api.twilio.com/2010-04-01/Accounts/[REDACTED]/Messages.json'

,'<httpHeader>' concat
'<header> name="basicAuth"
value="[REDACTED],[REDACTED]"</header>' concat
'<header> name="content-type"
value="application/x-www-form-urlencoded"</header>' concat
'</httpHeader>'

,cast('&To=[REDACTED]' concat
'&From=[REDACTED]' concat
'&MessagingServiceSid=[REDACTED]'
concat
'Body=Jays Twilio test' as
varchar(855))

);

the error message is...
"Server returned HTTP response code: 401 for URL:
https://api.twilio.com/2010-04-01/Accounts/[REDACTED]/Messages.json
The java store procedure or user-defined function aborted with a java
exception.


anyone have any idea?

Jay



On Sun, Nov 13, 2022 at 10:14 AM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

so under the realization that the older systools.httpgetclobverbose
appears to work with an xml format (and the new qsys2.get_clob is json)...
I changed my statement to the below...

values systools.httppostclob('
https://api.twilio.com/2010-04-01/Accounts/AC4c324053647a99e112233c8aa82f031c/Messages.json
'
,cast ('To=+14706411797' concat
'&From=+18622123201' concat

'&MessagingServiceSid=MG192f38d010096374bfa488b3b5ef9f5a' concat
'&Body=Jays Twillio test ' as
varchar(855))
--,cast(null as clob(1k))
,'<httpHeader>' concat
'<header
name="basicAuth":"AC4c324053647a99e112233c8aa82f031c,7a5443f5127522e2ff1aa0318c3b2f5d"/>'
concat
-- '<header
name="content-type,application/x-www-form-urlencoded"/>' concat
'</httpHeader>'
);

but still got the "Content not allowed in the prolog" so commented out my
"content-type" but still get the same message... so apparently "Content in
the prolog" is something else entirely.
maybe Twillio only supports receiving json???

anyone know what my solution could be?

tia

Jay


On Sun, Nov 13, 2022 at 9:58 AM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

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/AC8034fc51cbc9d5c2d2f5f6f62e349087/Messages.json
'
,cast(
'To=+15072501293' concat
'&From=+18124585123' concat
'&MessagingServiceSid=MGd93cb83d8dca78e0ed2fbebde6218741'
concat
'&Body=iSee Rest Text Message Test ' as varchar(855)
)

,'{"basicAuth":"AC8034fc51cbc9d5c2d2f5f6f62e349087,39363febbb9f802a0a145814e0a0fb44",

"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



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.