Symptom
When running an SMS report using the Reports API, there's an additional apostrophe ' in the body of the SMS.
Applies To
- SMS
- Reports API
Cause
The additional apostrophe was intentionally added to the message body to prevent CSV injection attacks. This is necessary to prevent "auto execution" within a spreadsheet.
Additional Information
https://owasp.org/www-community/attacks/CSV_Injection
Related to:
Articles in this section
- Why an apostrophe ' was returned in the body of my SMS reports when using Reports API?
- How does the Reports API pricing work?
- Why the inbound SMS records extracted from Reports API are different?
- What’s the maximum number of pending Reports API reports?
- Error Forbidden When Subaccount Tries to Request Reports from Reports API
- How can users check their reports API usage?
- How many Reports API requests can be submitted in a second?