Black List Automation

How can I automatically move the numbers in the black list to a Google Sheets sheet

Why would you want to do that?

I need for security check real time

from a shell

/usr/sbin/rasterisk -x ‘database show blacklist’

Thanks Dicko,

great method to see in real time but if I wanted to print in a google sheet for a remote operator

For that you will need to configure the Google docs api

Why not create a simple PHP script that outputs the command to an HTML table?

Yes thanks vespino it’s a good idea, but i need write e read the out file in a browser

You can also use the graphql stuff
Scope:

gql:blacklist:read

Query:

query{
  allBlacklists{
    blacklists{
      number
      description
    }
  }
}

Example out:

{
  "data": {
    "allBlacklists": {
      "blacklists": [
        {
          "number": "999999",
          "description": "1"
        }
      ]
    }
  }
}
1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.