The IPND CSV bulk upload lets carriers and resellers submit multiple IPND (Integrated Public Number Database) requests at once by emailing a CSV file to PracBill. This is ideal for bulk updates to phone number listings, such as adding new numbers, updating existing entries, or removing numbers from the directory.
This is a CSV-by-email integration, not a JSON endpoint. There is no API token or URL: you email the file, PracBill validates it, and you receive the results by email.
How it works:
Email attachment to your designated PracBill IPND submission addressSubmit a UTF-8 CSV file as an email attachment. The first row must be the column headers.
| Parameter | Type | Required | Description |
|---|---|---|---|
request_type |
string | Yes | Type of IPND request: add, update, remove |
phone_number |
string | Yes | The phone number: 8-15 digits (e.g. 0312345678) |
business_number |
string | Yes | Your business identifier: up to 20 characters |
business_name |
string | Yes | Business name: up to 100 characters |
business_address |
string | Yes | Business address: up to 255 characters |
customer_name |
string | Yes | Customer/contact name: up to 100 characters |
customer_address |
string | Yes | Customer address: up to 255 characters |
These columns are optional but can provide additional details.
| Parameter | Type | Required | Description |
|---|---|---|---|
abn |
string | No | Australian Business Number: 11 digits (validated) |
priority |
integer | No | Processing priority: 1 to 10 (default: 5) |
service_status |
string | No | Service connection status: C (Connected), D (Disconnected) |
list_code |
string | No | Directory listing type: LE (Listed), UL (Unlisted), SA (Silent Alternate) |
usage_code |
string | No | Usage classification: R (Residential), B (Business), G (Government), C (Community), N (Non-Classified) |
postcode |
string | No | Australian postcode: 4 digits |
state |
string | No | Australian state: NSW, VIC, QLD, WA, SA, TAS, ACT, NT |
locality |
string | No | Suburb/locality: up to 50 characters |
street_name |
string | No | Street name: up to 45 characters |
customer_name_2 |
string | No | Secondary customer name: up to 100 characters |
title |
string | No | Customer title: up to 50 characters (e.g. Mr, Ms, Dr) |
finding_name |
string | No | Directory finding name: up to 100 characters |
Request
Here is an example of a properly formatted CSV file.
request_type,phone_number,business_number,business_name,business_address,customer_name,customer_address,abn,priority,service_status,list_code,usage_code,postcode,state,locality,street_name
add,0312345678,BUS001,Acme Corporation,123 Business St Melbourne VIC 3000,John Smith,456 Customer Ave Sydney NSW 2000,12345678901,5,C,LE,B,3000,VIC,Melbourne,Business Street
add,0298765432,BUS002,XYZ Industries,789 Industrial Rd Brisbane QLD 4000,Jane Doe,321 Residential Blvd Perth WA 6000,,3,C,LE,B,4000,QLD,Brisbane,Industrial Road
update,0387654321,BUS001,Acme Corporation,123 Business St Melbourne VIC 3000,Updated Name,New Address Here,12345678901,8,C,LE,B,3000,VIC,Melbourne,Business Street
Tips:
"123 Main St, Suite 100"Response
Results are delivered by email.
If your CSV fails validation, you'll receive an error report. Common errors include:
| Error | Meaning | How to fix |
|---|---|---|
Missing required columns: [column_name] |
A required column is missing from your CSV | Add the missing column to your header row |
phone_number: Phone number must be between 8 and 15 digits |
Phone number has wrong length | Check the phone number format |
phone_number: Duplicate phone number within CSV file |
Same phone number appears twice | Remove the duplicate row |
phone_number: Phone number already has a pending request |
Number is already being processed | Wait for the existing request to complete |
abn: Invalid ABN format |
ABN doesn't pass validation | Verify the ABN is correct (11 digits) |
request_type: Must be add, update, or remove |
Invalid request type value | Use only add, update, or remove |
Column count mismatch |
Row has wrong number of columns | Check for missing or extra commas |
After submitting your CSV, you can track its progress.
| Status | Description |
|---|---|
pending |
File received, waiting to be processed |
validating |
File is being validated |
processing |
Requests are being created |
completed |
All requests successfully created |
failed |
Validation failed - check error report |
You will receive email updates at key stages:
If you encounter issues or have questions:
Related: Getting started with the API, API overview, Services API.