A script to extract all the responses to a certain number to a spreadsheet using the twilio cli

twilio_reponse_extractor.sh

#! /bin/bash

read -p "Please enter in the full number " assignedNumber

smsExportFile="$assignedNumber"_Responses_$(date +'%Y-%m-%d')".csv"

twilio api:core:messages:list --to=$number --properties=body,from,dateSent -o=tsv > $smsExportFile

# no need to custom parse the JSON

# twilio api:core:messages:list |
#  grep "inbound"  |
#  grep "$assignedNumber" |
#  awk '{print $1}' |
#  xargs -I {} twilio api:core:messages:fetch --sid {} -o json | 
#  jq '.[]| "\"" + .body + "\"" + "," + "\"" + .from + "\"" + "," + "\"" + (.dateSent|tostring) + "\""' |
#  sed 's/\\//g' |
#  sed -E 's/^"(.*)"$/\1/g' >> $smsExportFile