x

Add high-performance, fully programmable video to any application with the new SignalWire Video API

List LaML Messages to CSV (NodeJS)

List messages in your SignalWire Project.

Cassie Bowles | Technical Success Manager

May 24, 2021

Why do you need it?

This snippet might be helpful to you if you need to pull your message records from SignalWire into a more readable format or somewhere easy to store. You can use one or more of the following parameters to further filter your records and return only the specific information that you need: DateSent, From, To, and Status.

You can read more about the List Messages API here.

What does it do?

This code will query your project and return all of the messages (both inbound and outbound) within your project, limited by whatever parameters you choose to use. This example shows how to filter all messages by a particular date range and status. It will then take this data and insert it into a CSV for your records or further use.


Technical Specifications

You must have the SignalWire NodeJS SDK installed. You can install that here.


Change the following variables
  1. ProjectID: Your project ID is an alphanumeric string that tells the SignalWire SDK where to find your project. You can find this in an easily copyable format by going to your SignalWire Portal and clicking the API tab on the left-hand side.

  2. AuthToken: Your Auth Token is an alphanumeric string that helps to authenticate your HTTP requests to SignalWire. You can create this (if you haven’t already) or copy this in an easily copyable format by going to your SignalWire Portal and clicking the API tab. If you have not created an API token, press the blue new button. If you have, click show and copy the string.

  3. SpaceURL: Your space URL is the domain of your space, i.e. example.signalwire.com. This can also be found in an easily copyable format within the API tab in your SignalWire space.

  4. Change the date and status when calling clients.messages.list() to specify the date range and status that you need. If you are filtering by another parameter, you can add it within client.messages.list()


Step by step guide with the code


Comments

This snippet uses the NodeJS SDK to query the SignalWire API and return all the message data matching the parameters you choose to set. This data is then inserted row by row into a CSV file:

  • From phone number

  • To phone number

  • Date

  • Status (queued, sending, sent, delivered, undelivered, failed, receiving, received)

  • MessageSID (361d7f20-f30d-4baf-b8ca-c7912dleaacf)

  • Price

  • Direction


Getting Started Guide

If you are looking for more information about using SignalWire, refer to our Getting Started guide.

Please feel free to reach out to us on our Community Slack or create a Support ticket if you need guidance!


Start a free trial

If you would like to test this example out, you can create a SignalWire account and space here.