1

I'm testing out multiple sms providers, and I'm using the api to do reads for reporting on the back end, but I can't seem to figure out how the system knows which sms provider sent a particular sms. The Activity table doesn't seem to have provider_id reference of any kind unless I'm missing it. Is it in an attached table or something? I can't find a list of providers either. Is that in the database?

2
  • Which if any sms based extensions are you using? Feb 10, 2020 at 0:17
  • Just Twilio at the moment, but looking to use a new one in addition Mar 21, 2020 at 16:34

1 Answer 1

1

From the db schema https://doc.symbiotic.coop/dev/civicrm/latest/schema/tables/civicrm_sms_provider.html

It looks like you might be after the sms_provider_id from the civicrm_mailing table, or sms_provider_id from the civicrm_action_schedule table.

1
  • I found the one in action_schedule, but that table is empty, so I think that's only scheduled items, and I've never scheduled anything ahead of time, so that makes sense. The mailing table doesn't look complete either. There are recent outgoing sms messages that don't appear, and in fact the table only has 19 entries total, and only 5 with the subject populated. Any clue where the rest of the data might be? Feb 9, 2020 at 22:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.