How can I query inSMS in a technical workflow? | Community
Skip to main content
E
ewelgat
October 13, 2020
Solved

How can I query inSMS in a technical workflow?

  • October 13, 2020
  • 1 reply
  • 1338 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ewelgat
And of course - as soon as I post this I find it.

1 reply

J
JohnWi12
Level 5
October 14, 2020

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.

 

 

    E
    ewelgatAuthor
    October 14, 2020
    My problem is more basic - I can't find the InSMS table anywhere in the Query explorer.
    Terms & ConditionsAccessibility statement

    Loading footer...