Chilkat Online Tools

Foxpro / Twilio Messaging / SMS / Find available phone numbers

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loQueryParams
LOCAL loResp
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcAddress_requirements
LOCAL lnBeta
LOCAL lcFriendly_name
LOCAL lcIso_country
LOCAL lcLata
LOCAL lcLatitude
LOCAL lcLocality
LOCAL lcLongitude
LOCAL lcPhone_number
LOCAL lcPostal_code
LOCAL lcRate_center
LOCAL lcRegion
LOCAL lnV_end
LOCAL lcFirst_page_uri
LOCAL lcNext_page_uri
LOCAL lnPage
LOCAL lnPage_size
LOCAL lcPrevious_page_uri
LOCAL lnStart
LOCAL lcUri
LOCAL i
LOCAL lnCount_i

* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')

loHttp.BasicAuth = 1
loHttp.Login = "{{TWILIO_ACCOUNT_SID}}"
loHttp.Password = "{{TWILIO_AUTH_TOKEN}}"

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loQueryParams = CreateObject('Chilkat.JsonObject')
loQueryParams.UpdateString("SmsEnabled","true")

loResp = loHttp.QuickRequestParams("GET","https://api.twilio.com/2010-04-01/Accounts/:AccountSid/AvailablePhoneNumbers/:CountryCode/Local.json",loQueryParams)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loQueryParams
    CANCEL
ENDIF

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbResponseBody = CreateObject('Chilkat.StringBuilder')
loResp.GetBodySb(loSbResponseBody)

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJResp = CreateObject('Chilkat.JsonObject')
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = 0

? "Response Body:"
? loJResp.Emit()

lnRespStatusCode = loResp.StatusCode
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
    ? "Response Header:"
    ? loResp.Header
    ? "Failed."
    RELEASE loResp
    RELEASE loHttp
    RELEASE loQueryParams
    RELEASE loSbResponseBody
    RELEASE loJResp
    CANCEL
ENDIF

RELEASE loResp

* Sample JSON response:
* (Sample code for parsing the JSON response is shown below)

* {
*   "available_phone_numbers": [
*     {
*       "address_requirements": "aute eiusmod",
*       "beta": true,
*       "capabilities": {},
*       "friendly_name": "nisi do",
*       "iso_country": "voluptate",
*       "lata": "minim cillum",
*       "latitude": 4649799.109687477,
*       "locality": "in Duis ut anim irure",
*       "longitude": -94614168.65959848,
*       "phone_number": "amet labore",
*       "postal_code": "deserunt esse cillum ut",
*       "rate_center": "velit",
*       "region": "ipsum pariatur cupidatat dolor"
*     },
*     {
*       "address_requirements": "Ut",
*       "beta": true,
*       "capabilities": {},
*       "friendly_name": "ullamco",
*       "iso_country": "in incididunt",
*       "lata": "cillum dolor velit sed",
*       "latitude": -21235506.84035504,
*       "locality": "sint",
*       "longitude": -25668838.90140347,
*       "phone_number": "non adipisicing enim incididunt deserunt",
*       "postal_code": "ut voluptate minim",
*       "rate_center": "velit aliqua",
*       "region": "Excepteur aliquip in nisi"
*     }
*   ],
*   "end": 3504435,
*   "first_page_uri": "http://nnYdJBuOCqryvmKnbvBPBnaNMbCqrxw.tdvyHFVoZISsFUqJvqFT0cg+",
*   "next_page_uri": "http://PoqRnDNQHgsSAILsyYutOtNGDj.qqhjm8TRty6qyZnDJAQcH1Djqzpuv,w5pf+hzR.4snyBz",
*   "page": 90555719,
*   "page_size": 88924560,
*   "previous_page_uri": "https://ArZjnsEHjpSMJWeIOQAYyTOm.ispdr0ZozBph6JkyS4wCN4KsLijal5vGd-yowauXTc55dxOb",
*   "start": -60781383,
*   "uri": "http://BJmswSvlkWlnMst.fiODjnzufdg.eBwAEpkSmwiU.e-Ygm,OFGiH"
* }

* Sample code for parsing the JSON response...
* Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code

lnV_end = loJResp.IntOf("end")
lcFirst_page_uri = loJResp.StringOf("first_page_uri")
lcNext_page_uri = loJResp.StringOf("next_page_uri")
lnPage = loJResp.IntOf("page")
lnPage_size = loJResp.IntOf("page_size")
lcPrevious_page_uri = loJResp.StringOf("previous_page_uri")
lnStart = loJResp.IntOf("start")
lcUri = loJResp.StringOf("uri")
i = 0
lnCount_i = loJResp.SizeOfArray("available_phone_numbers")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcAddress_requirements = loJResp.StringOf("available_phone_numbers[i].address_requirements")
    lnBeta = loJResp.BoolOf("available_phone_numbers[i].beta")
    lcFriendly_name = loJResp.StringOf("available_phone_numbers[i].friendly_name")
    lcIso_country = loJResp.StringOf("available_phone_numbers[i].iso_country")
    lcLata = loJResp.StringOf("available_phone_numbers[i].lata")
    lcLatitude = loJResp.StringOf("available_phone_numbers[i].latitude")
    lcLocality = loJResp.StringOf("available_phone_numbers[i].locality")
    lcLongitude = loJResp.StringOf("available_phone_numbers[i].longitude")
    lcPhone_number = loJResp.StringOf("available_phone_numbers[i].phone_number")
    lcPostal_code = loJResp.StringOf("available_phone_numbers[i].postal_code")
    lcRate_center = loJResp.StringOf("available_phone_numbers[i].rate_center")
    lcRegion = loJResp.StringOf("available_phone_numbers[i].region")
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loQueryParams
RELEASE loSbResponseBody
RELEASE loJResp

Curl Command

curl -G -d "SmsEnabled=true"
	-u '{{TWILIO_ACCOUNT_SID}}:{{TWILIO_AUTH_TOKEN}}'
https://api.twilio.com/2010-04-01/Accounts/:AccountSid/AvailablePhoneNumbers/:CountryCode/Local.json

Postman Collection Item JSON

{
  "name": "Find available phone numbers",
  "request": {
    "auth": {
      "type": "basic",
      "basic": [
        {
          "key": "password",
          "value": "{{TWILIO_AUTH_TOKEN}}",
          "type": "string"
        },
        {
          "key": "username",
          "value": "{{TWILIO_ACCOUNT_SID}}",
          "type": "string"
        }
      ]
    },
    "method": "GET",
    "header": [
    ],
    "url": {
      "raw": "{{2010-04-01-Accounts-AccountSid-AvailablePhoneNumbers-CountryCode-Local.json-Url}}/2010-04-01/Accounts/:AccountSid/AvailablePhoneNumbers/:CountryCode/Local.json?SmsEnabled=true",
      "host": [
        "{{2010-04-01-Accounts-AccountSid-AvailablePhoneNumbers-CountryCode-Local.json-Url}}"
      ],
      "path": [
        "2010-04-01",
        "Accounts",
        ":AccountSid",
        "AvailablePhoneNumbers",
        ":CountryCode",
        "Local.json"
      ],
      "query": [
        {
          "key": "AreaCode",
          "value": "<integer>",
          "description": "The area code of the phone numbers to read. Applies to only phone numbers in the US and Canada.",
          "disabled": true
        },
        {
          "key": "Contains",
          "value": "<string>",
          "description": "The pattern on which to match phone numbers. Valid characters are `*`, `0-9`, `a-z`, and `A-Z`. The `*` character matches any single digit. For examples, see [Example 2](https://www.twilio.com/docs/phone-numbers/api/availablephonenumberlocal-resource?code-sample=code-find-phone-numbers-by-number-pattern) and [Example 3](https://www.twilio.com/docs/phone-numbers/api/availablephonenumberlocal-resource?code-sample=code-find-phone-numbers-by-character-pattern). If specified, this value must have at least two characters.",
          "disabled": true
        },
        {
          "key": "SmsEnabled",
          "value": "true",
          "description": "Whether the phone numbers can receive text messages. Can be: `true` or `false`."
        },
        {
          "key": "MmsEnabled",
          "value": "<boolean>",
          "description": "Whether the phone numbers can receive MMS messages. Can be: `true` or `false`.",
          "disabled": true
        },
        {
          "key": "VoiceEnabled",
          "value": "<boolean>",
          "description": "Whether the phone numbers can receive calls. Can be: `true` or `false`.",
          "disabled": true
        },
        {
          "key": "ExcludeAllAddressRequired",
          "value": "<boolean>",
          "description": "Whether to exclude phone numbers that require an [Address](https://www.twilio.com/docs/usage/api/address). Can be: `true` or `false` and the default is `false`.",
          "disabled": true
        },
        {
          "key": "ExcludeLocalAddressRequired",
          "value": "<boolean>",
          "description": "Whether to exclude phone numbers that require a local [Address](https://www.twilio.com/docs/usage/api/address). Can be: `true` or `false` and the default is `false`.",
          "disabled": true
        },
        {
          "key": "ExcludeForeignAddressRequired",
          "value": "<boolean>",
          "description": "Whether to exclude phone numbers that require a foreign [Address](https://www.twilio.com/docs/usage/api/address). Can be: `true` or `false` and the default is `false`.",
          "disabled": true
        },
        {
          "key": "Beta",
          "value": "<boolean>",
          "description": "Whether to read phone numbers that are new to the Twilio platform. Can be: `true` or `false` and the default is `true`.",
          "disabled": true
        },
        {
          "key": "NearNumber",
          "value": "<string>",
          "description": "Given a phone number, find a geographically close number within `distance` miles. Distance defaults to 25 miles. Applies to only phone numbers in the US and Canada.",
          "disabled": true
        },
        {
          "key": "NearLatLong",
          "value": "<string>",
          "description": "Given a latitude/longitude pair `lat,long` find geographically close numbers within `distance` miles. Applies to only phone numbers in the US and Canada.",
          "disabled": true
        },
        {
          "key": "Distance",
          "value": "<integer>",
          "description": "The search radius, in miles, for a `near_` query.  Can be up to `500` and the default is `25`. Applies to only phone numbers in the US and Canada.",
          "disabled": true
        },
        {
          "key": "InPostalCode",
          "value": "<string>",
          "description": "Limit results to a particular postal code. Given a phone number, search within the same postal code as that number. Applies to only phone numbers in the US and Canada.",
          "disabled": true
        },
        {
          "key": "InRegion",
          "value": "<string>",
          "description": "Limit results to a particular region, state, or province. Given a phone number, search within the same region as that number. Applies to only phone numbers in the US and Canada.",
          "disabled": true
        },
        {
          "key": "InRateCenter",
          "value": "<string>",
          "description": "Limit results to a specific rate center, or given a phone number search within the same rate center as that number. Requires `in_lata` to be set as well. Applies to only phone numbers in the US and Canada.",
          "disabled": true
        },
        {
          "key": "InLata",
          "value": "<string>",
          "description": "Limit results to a specific local access and transport area ([LATA](https://en.wikipedia.org/wiki/Local_access_and_transport_area)). Given a phone number, search within the same [LATA](https://en.wikipedia.org/wiki/Local_access_and_transport_area) as that number. Applies to only phone numbers in the US and Canada.",
          "disabled": true
        },
        {
          "key": "InLocality",
          "value": "<string>",
          "description": "Limit results to a particular locality or city. Given a phone number, search within the same Locality as that number.",
          "disabled": true
        },
        {
          "key": "FaxEnabled",
          "value": "<boolean>",
          "description": "Whether the phone numbers can receive faxes. Can be: `true` or `false`.",
          "disabled": true
        },
        {
          "key": "PageSize",
          "value": "<integer>",
          "description": "How many resources to return in each list page. The default is 50, and the maximum is 1000.",
          "disabled": true
        }
      ],
      "variable": [
        {
          "key": "AccountSid",
          "value": "{{TWILIO_ACCOUNT_SID}}",
          "description": "(Required) The SID of the [Account](https://www.twilio.com/docs/iam/api/account) requesting the AvailablePhoneNumber resources."
        },
        {
          "key": "CountryCode",
          "value": "US",
          "description": "(Required) The [ISO-3166-1](https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2) country code of the country from which to read phone numbers."
        }
      ]
    },
    "description": "To send an SMS with Twilio you'll first need to buy a phone number. For that you have to search the catalog of available phone numbers.\n\nOnce you have the list of available phone numbers, pick one and use it in the next request to buy the number.\n\nLearn more about this in the [Twilio Docs](https://www.twilio.com/docs/phone-numbers/api/availablephonenumberlocal-resource)."
  },
  "response": [
    {
      "name": "OK",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": "Added as a part of security scheme: basic",
            "key": "Authorization",
            "value": "Basic <credentials>"
          }
        ],
        "url": {
          "raw": "{{2010-04-01-Accounts-AccountSid-AvailablePhoneNumbers-CountryCode-Local.json-Url}}/2010-04-01/Accounts/:AccountSid/AvailablePhoneNumbers/:CountryCode/Local.json?AreaCode=<integer>&Contains=<string>&SmsEnabled=<boolean>&MmsEnabled=<boolean>&VoiceEnabled=<boolean>&ExcludeAllAddressRequired=<boolean>&ExcludeLocalAddressRequired=<boolean>&ExcludeForeignAddressRequired=<boolean>&Beta=<boolean>&NearNumber=<string>&NearLatLong=<string>&Distance=<integer>&InPostalCode=<string>&InRegion=<string>&InRateCenter=<string>&InLata=<string>&InLocality=<string>&FaxEnabled=<boolean>&PageSize=<integer>",
          "host": [
            "{{2010-04-01-Accounts-AccountSid-AvailablePhoneNumbers-CountryCode-Local.json-Url}}"
          ],
          "path": [
            "2010-04-01",
            "Accounts",
            ":AccountSid",
            "AvailablePhoneNumbers",
            ":CountryCode",
            "Local.json"
          ],
          "query": [
            {
              "key": "AreaCode",
              "value": "<integer>"
            },
            {
              "key": "Contains",
              "value": "<string>"
            },
            {
              "key": "SmsEnabled",
              "value": "<boolean>"
            },
            {
              "key": "MmsEnabled",
              "value": "<boolean>"
            },
            {
              "key": "VoiceEnabled",
              "value": "<boolean>"
            },
            {
              "key": "ExcludeAllAddressRequired",
              "value": "<boolean>"
            },
            {
              "key": "ExcludeLocalAddressRequired",
              "value": "<boolean>"
            },
            {
              "key": "ExcludeForeignAddressRequired",
              "value": "<boolean>"
            },
            {
              "key": "Beta",
              "value": "<boolean>"
            },
            {
              "key": "NearNumber",
              "value": "<string>"
            },
            {
              "key": "NearLatLong",
              "value": "<string>"
            },
            {
              "key": "Distance",
              "value": "<integer>"
            },
            {
              "key": "InPostalCode",
              "value": "<string>"
            },
            {
              "key": "InRegion",
              "value": "<string>"
            },
            {
              "key": "InRateCenter",
              "value": "<string>"
            },
            {
              "key": "InLata",
              "value": "<string>"
            },
            {
              "key": "InLocality",
              "value": "<string>"
            },
            {
              "key": "FaxEnabled",
              "value": "<boolean>"
            },
            {
              "key": "PageSize",
              "value": "<integer>"
            }
          ],
          "variable": [
            {
              "key": "AccountSid"
            },
            {
              "key": "CountryCode"
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n \"available_phone_numbers\": [\n  {\n   \"address_requirements\": \"aute eiusmod\",\n   \"beta\": true,\n   \"capabilities\": {},\n   \"friendly_name\": \"nisi do\",\n   \"iso_country\": \"voluptate\",\n   \"lata\": \"minim cillum\",\n   \"latitude\": 4649799.109687477,\n   \"locality\": \"in Duis ut anim irure\",\n   \"longitude\": -94614168.65959848,\n   \"phone_number\": \"amet labore\",\n   \"postal_code\": \"deserunt esse cillum ut\",\n   \"rate_center\": \"velit\",\n   \"region\": \"ipsum pariatur cupidatat dolor\"\n  },\n  {\n   \"address_requirements\": \"Ut\",\n   \"beta\": true,\n   \"capabilities\": {},\n   \"friendly_name\": \"ullamco\",\n   \"iso_country\": \"in incididunt\",\n   \"lata\": \"cillum dolor velit sed\",\n   \"latitude\": -21235506.84035504,\n   \"locality\": \"sint\",\n   \"longitude\": -25668838.90140347,\n   \"phone_number\": \"non adipisicing enim incididunt deserunt\",\n   \"postal_code\": \"ut voluptate minim\",\n   \"rate_center\": \"velit aliqua\",\n   \"region\": \"Excepteur aliquip in nisi\"\n  }\n ],\n \"end\": 3504435,\n \"first_page_uri\": \"http://nnYdJBuOCqryvmKnbvBPBnaNMbCqrxw.tdvyHFVoZISsFUqJvqFT0cg+\",\n \"next_page_uri\": \"http://PoqRnDNQHgsSAILsyYutOtNGDj.qqhjm8TRty6qyZnDJAQcH1Djqzpuv,w5pf+hzR.4snyBz\",\n \"page\": 90555719,\n \"page_size\": 88924560,\n \"previous_page_uri\": \"https://ArZjnsEHjpSMJWeIOQAYyTOm.ispdr0ZozBph6JkyS4wCN4KsLijal5vGd-yowauXTc55dxOb\",\n \"start\": -60781383,\n \"uri\": \"http://BJmswSvlkWlnMst.fiODjnzufdg.eBwAEpkSmwiU.e-Ygm,OFGiH\"\n}"
    }
  ]
}