Answers.Body: <p>From the db schema <a href="https://doc.symbiotic.coop/dev/civicrm/latest/schema/tables/civicrm_sms_provider.html" rel="nofollow noreferrer">https://doc.symbiotic.coop/dev/civicrm/latest/schema/tables/civicrm_sms_provider.html</a></p>
  
  <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-02-09T22:35:45.300Z
Answers.Text: 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?
Answers.UserDisplayName: Jason Miller
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-02-09T21:14:37.583Z
Answers.LastActivityDate: 2020-02-09T21:14:37.583Z
Answers.UserDisplayName: Luke Stewart
Body: <p>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?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-02-10T00:17:27.743Z
Comments.Text: Which if any sms based extensions are you using?
Comments.UserDisplayName: Luke Stewart
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-03-21T16:34:11.237Z
Comments.Text: Just Twilio at the moment, but looking to use a new one in addition
Comments.UserDisplayName: Jason Miller
Tags: <api><database><sms><civisms>
Title: outgoing sms activity link to provider when using multiple providers?
ThreadText: # outgoing sms activity link to provider when using multiple providers?
  
  (Asked by: username_0 on 2020-02-09)
  
  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?
  
  **Tags:** api, database, sms, civisms
  
  > **Comments:**
  > **username_1**: Which if any sms based extensions are you using?  
  > **username_0**: Just Twilio at the moment, but looking to use a new one in addition  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-02-09. Score: 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.
  
  > **Comments:**
  > **username_0**: 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?  
  
  ---
  
  