Number Lookup: Database cleaning

You’ve sent promotional messages to your customers, then analyzed the delivery reports and found out that your phone number database has a lot of invalid numbers. You may consider cleaning it up with our Number Lookup solution.

Number Lookup enables identifying unused and inactive numbers or the network which your customer is currently using. We’re offering three distinct packages tailor-made for three types of enterprise clients.

In order to clean up your database, you need to have our Database Cleaning package and perform Number Lookup with an HTTP POST request:

• JSON

POST /number/1/query HTTP/1.1
Host: api.infobip.com
Authorization: Basic QWxhZGRpbjpvcGVuIHNlc2FtZQ==
Content-Type: application/json

{  
   "to":["41793026834"]
}	
  

In this example we used only one phone number to make it easier to follow. Depending of the package, the response will be something like this:

• JSON

HTTP/1.1 200 OK
Content-Type: application/json

{  
   "results":[  
      {  
         "to":"41793026834",
         "mccMnc":"22801",
         "imsi":"228012123477789",
         "originalNetwork":{  
            "networkPrefix":"79",
            "countryPrefix":"41"
         },
         "ported":false,
         "roaming":false,
         "status":{  
            "groupId":3,
            "groupName":"DELIVERED",
            "id":5,
            "name":"DELIVERED_TO_HANDSET",
            "description":"Message delivered to handset"
         },
         "error":{  
            "groupId":0,
            "groupName":"OK",
            "id":0,
            "name":"NO_ERROR",
            "description":"No Error",
            "permanent":false
         }
      }
   ]
}	
  

From the information you will receive in the Number Lookup response, you can learn whether a phone number is valid or not. Here is the list of available Number Lookup parameters per package and also the list of available statuses.

For example, 30 phone numbers are invalid and 70 are valid, so you decide to remove the 30 invalid ones from your database. This will save you up to 30% of SMS sending costs and you can invite more active subscribers with the same budget.