Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How can I query inSMS in a technical workflow?

ewelgat
Level 1
Level 1

I've seen a number of posts about older versions of Campaign  and the inSMS table.  We would like to setup a workflow to process the records in this table on a 10 minute basis to set some field values based on reply codes received.  I'm struggling to find out how to select from this table within a query action in the workflow.  Can anyone provide info on how to query this table?

1 Accepted Solution
ewelgat
Correct answer by
Level 1
Level 1
And of course - as soon as I post this I find it.

View solution in original post

2 Replies
johnwwilcoxmba
Level 5
Level 5

Use table Incoming SMS (InSMS).  You have limited number of fields to query.  But you can get both sending and receiving phone numbers, and the message that was sent.  Unfortunately you have to substring out the phone numbers.

 

johnwwilcoxmba_0-1602685527743.png

 

ewelgat
Level 1
Level 1
My problem is more basic - I can't find the InSMS table anywhere in the Query explorer.
ewelgat
Correct answer by
Level 1
Level 1
And of course - as soon as I post this I find it.

View solution in original post