How can I query inSMS in a technical workflow?

Avatar

Avatar
Validate 1
Level 1
ewelgat
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
ewelgat
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
ewelgat
Level 1

13-10-2020

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?

View Entire Topic

Avatar

Avatar
Validate 1
Level 4
johnwwilcoxmba
Level 4

Likes

38 likes

Total Posts

86 posts

Correct reply

15 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 1
Level 4
johnwwilcoxmba
Level 4

Likes

38 likes

Total Posts

86 posts

Correct reply

15 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile
johnwwilcoxmba
Level 4

14-10-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.

 

johnwwilcoxmba_0-1602685527743.png