Zum Hauptinhalt springen

SOAP API

Purpose

Accessing to a number of PBX databases serves as an excellent purpose to manage PBX servers from a single remote host management system. The type of access protocol we currently provide is Simple Object Access Protocol (SOAP). This protocol borrows from the well-known Hyper-Text Transfer Protocol(HTTP) which gives web developers and even software engineering with much more power and extensibility with the web/stand-alone application than what the HTTP and basic object/modular collaboration provides. In this article, the basic requirement is that you have at least the fundamental understanding of how HTTP functions and it's request/response mechanism, and follow the proper syntax as described below. SOAP can be pretty simple as HTTP and all of that HTML syntaxes, however it is much more evolved and is becoming a widly accepted standard. The Internet Engineering Task Force (IETF) and the Request For Comment (RFC) entities have incorporated the protocol along with their documentation. If you are interested in comprehensively understanding in what and how SOAP works in great details, it is recommended that you start here

The main SOAP request functions that accesses the PBX database are identified as:

  • DBIndex -> DBIndexResponse
  • DBSearch -> DBSearchResponse
  • DBGet -> DBGetResponse
  • DBSet -> DBSetResponse
  • CreateExtension -> CreateExtensionResponse
  • DeleteExtension -> DeleteExtensionResponse
  • CreatePaging -> CreatePagingResponse
  • DeletePaging -> DeletePagingResponse
  • CreateDialplan -> CreateDialplanResponse
  • DeleteDialplan -> DeleteDialplanResponse
  • CreateTrunk -> CreateTrunkResponse
  • DeleteTrunk -> DeleteTrunkResponse
  • AddCredit -> AddCreditResponse
  • CreateAccount -> CreateAccountResponse(*)
  • ModifyAccount -> ModifyAccountResponse (*)
  • DeleteAccount -> DeleteAccountResponse (*)
  • ScheduleConference -> ScheduleConferenceResponse(*)
  • ModifyConference -> ModifyConferenceResponse (*)
  • DeleteConference -> DeleteConferenceResponse (*)

(*) - Functionality supported from version 2011-5.0.0.1052 onwards.

Applicable Table names and Column names can be found in the end of this article.

info

Note: After submitting with DBSet, it will return a DBSetResponse with the respective index tag e.g. <Index>56</Index>. DBSearch, DBIndex and DBGet will return meaningful data in the response. CreateExtension will return the index of the created extension if successful else it returns an index '0'. The DeleteExtension will return 'true' or 'false' as the response.

info

Note: There are currently no error-checking in this database access. For instance, if you submit a DBGet or DBSearch query with invalid table name and/or invalid column name(s), it will still return a DBResultset with the index tag (<Index>), in some case it may return a null value which usually means that the request is not being sent in correct text encoding such as using the ASCII format instead of UTF-8 format. This error-checking feature will be added soon.

There are also some helper function and an XML parser utilities to simplify such as encapsulating the required SOAP envelopes as well as generating DBIndex/DBSearch/DBGet/DBSet/CreateExtension/DeleteExtension text for the PBX server. This will give IT professionals much greater control of the system especially when:

  • Another PBX needs to be created in a remote location on-the-fly
  • Automate creation of accounts, trunks and dial plans
  • Back-up all new data in real time
  • Store an exact database replica into a RDBMS such as Oracle and MySQL, for better statistics and fast restoration in case of failure.

`Note: In order to use the below functions/messages successfully, make sure that the IP address of the sending computer(device) is set under "Admin->Settings->General->SOAP Trusted IP".`

Primary Functions

DBSearch function

DBSearch function is an index procedure that will search all matching entries of a given table. This function is important, because it will return a list of indexes of matching "where clauses", a parameter named args, so that you can get and set the value(s) by using the given identification provided by this function: pbx_search( table, max, skip, back, args, &result_sets ) equilavent of SQL command:

SELECT id from table WHERE args(key) = args(value) LIMIT( skip, max )

$args = array( cfn_timeout=>"10", name=>"localhost" );

pbx_search("domains", 10, 0, false, $args, $result_set );

echo "results:

"; print_r( $result_set );

will produce the request:


`POST /soap.xml HTTP/1.1 Content-Type: application/xml Content-Length: 351 <?xml version="1.0" standalone="yes"?> <env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "><env:Body><sns:DBSearch> <Table>domains</Table> <Max>10</Max> <Column> <Name>cfn_timeout</Name> <Value>10</Value> </Column> <Column> <Name>name</Name> <Value>localhost</Value> </Column></sns:DBSearch></env:Body></env:Envelope>`

and in return:


`HTTP/1.1 200 Ok Date: Wed, 27 Jun 2007 00:00:00 GMT Content-Length: 207 Server: pbxnsip/2.0.3.1715 (Win32) Cache-Control: no-cache Content-Type: text/xml <env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://pbxnsip.com/soap/pbx](http://pbxnsip.com/soap/pbx) "><env:Body><sns:DBSearchResponse> <Index>2</Index></sns:DBSearchResponse></env:Body></env:Envelope>`

result: Array ( [2] => 2 )

As you can see, the script found a domain that has a domain.cfn_timeout that was equal to 2 and domain.name equal to "localhost", therefore the domain name "localhost" has an id of 2 as shown in the index tag's value as well as the command print_r( $result_set) (in the print_r( ARRAY ) function, both key and value reflects the domain's id/Index).

DBGet Function

function pbx_get( table, row, columns, &result_set ) equilavent of SQL command:

SELECT columns(value) from table WHERE id = row

To make a request for certain data, for example let's request the name and id of table domain_alias id #2, the following codes would look like the this: $columns = array( 0=>"name"); pbx_get( "domain_alias", 2, $columns, $result_set ); print_r( $result_set ); the function pbx_get() will query the PBX like the following:


`POST /soap.xml HTTP/1.1Content-Type: application/xml Content-Length: 288 <?xml version="1.0" standalone="yes"?> <env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:DBGet> < Table>domain_alias< /Table> <Index>2</Index> <Column> <Name>name</Name> </Column> </sns:DBGet> </env:Body></env:Envelope>`

In response we would get the following:


`HTTP/1.1 200 Ok Date: Tue, 26 Jun 2007 00:00:00 GMT Content-Length: 243 Server: pbxnsip/2.0.3.1715 (Win32) Cache-Control: no-cache Content-Type: text/xml <env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://pbxnsip.com/soap/pbx](http://pbxnsip.com/soap/pbx) "><env:Body><sns:DBGetResponse> <Column> <Name>name</Name> <Value>localhost</Value> </Column></sns:DBGetResponse></env:Body></env:Envelope>`

and print_r( $result_set ) will produce an output:

Array ( [name] => localhost )

DBSet Function

function pbx_set( table_name, row, columns_args ) To set number of values, such as changing the display_name and an email_address from table Users where id is 12: equilavent of SQL command:

UPDATE table SET columns_args(key) = columns_args(value) WHERE id = row

$columns_args = array( email_address=>"john@doe.com", display_name=>"John Doe" ); pbx_set( "users", "12", $columns_args, "localhost", "8080" );

These code will produce a request to the PBX like the following


`POST /soap.xml HTTP/1.1 Content-Type: application/xml Content-Length: 388 <?xml version="1.0" standalone="yes"?> <env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "><env:Body><sns:DBSet> <Table>extensions</Table> <Index>12</Index> <Column> <Name>email_address</Name> <Value>john@doe.com</Value> </Column> <Column> <Name>display_name</Name> <Value>John Doe</Value> </Column></sns:DBSet></env:Body></env:Envelope>`

And in response:


`HTTP/1.1 200 Ok Date: Tue, 26 Jun 2007 00:00:00 GMT Content-Length: 202 Server: pbxnsip/2.0.3.1715 (Win32) Cache-Control: no-cache Content-Type: text/xml <env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://pbxnsip.com/soap/pbx](http://pbxnsip.com/soap/pbx) "><env:Body><sns:DBSetResponse> <Index>12</Index></sns:DBSetResponse></env:Body></env:Envelope>`

CreateExtension

CreateExtension function is a special function to create the extensions in the PBX. Note that this function cannot be used to create any other type of the accounts. The <Domain> and <Extension> tags are mandatory for CreateExtension function. You can also set other parameters while creating the extension. You can view the available Extension fields here

An example syntax is shown below. More information on the extensions can be found under the section for Extension

An example syntax is shown below.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 364 <?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:CreateExtension> <Domain>localhost</Domain> <Extension>633</Extension> <first_name>John</first_name> <display_name>Smith</display_name> </sns:CreateExtension> </env:Body></env:Envelope>`

The response will contain the index of the created extension if successful. Otherwise, the response will contain 0 (zero).


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 215<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:CreateExtensionResponse> <Index>101</Index> </sns:CreateExtensionResponse> </env:Body></env:Envelope>`

DeleteExtension

DeleteExtension function is a special function to delete the extensions in the PBX. Note that this function cannot be used to delete any other type of the accounts. The <Domain> and <Extension> tags are mandatory for DeleteExtension function.

An example syntax is shown below.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 297<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:DeleteExtension> <Extension>633</Extension> <Domain>localhost</Domain> </sns:DeleteExtension> </env:Body></env:Envelope>`

The response will contain 'true' if the extension is deleted successfully. Otherwise, the response will contain false.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 210<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:DeleteExtensionResponse> <Ok>true</Ok> </sns:DeleteExtensionResponse> </env:Body></env:Envelope>`

CreatePaging

CreatePaging function is a special function to create the paging groups in the PBX. Note that this function cannot be used to create any other type of the accounts. The <Domain> and <Name> tags are mandatory for CreatePaging function. You can also set other parameters while creating the paging group. You can view the available paging fields here

An example syntax is shown below. More information on the paging can be found under the section for Paging


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 372 <?xml version="1.0" standalone="yes"?> <env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:CreatePaging> <Domain>localhost</Domain> <Name>805</Name> <mode>unicast</mode> <ext>601 602</ext> <perm>*</perm> <display>Hill-Rom</display> </sns:CreatePaging> </env:Body> </env:Envelope>`

If the paging creation is successful, PBX will send back the index of the paging group. Otherwise, PBX will send back zero (0).


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 208<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:CreatePagingResponse> <Index>47</Index> </sns:CreatePagingResponse> </env:Body></env:Envelope>`

DeletePaging

DeletePaging function is a special function to delete the paging group in the PBX. Note that this function cannot be used to delete any other type of the accounts. The <Domain> and <Name> tags are mandatory for DeletePaging function.

An example syntax is shown below.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 285 <?xml version="1.0" standalone="yes"?> <env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:DeletePaging> <Name>805</Name> <Domain>localhost</Domain> </sns:DeletePaging> </env:Body> </env:Envelope>`

The response will contain 'true' if the delete successful. Otherwise, the response will contain 'false'.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 204<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:DeletePagingResponse> <Ok>true</Ok> </sns:DeletePagingResponse> </env:Body></env:Envelope>`

CreateDialplan

CreateDialplan function is a special function to create the dialplans in the PBX. The <Domain> and <Name> tags are mandatory for CreateDialplan function. You can also set trunk association, patterns and replacement strings while creating the dialplan. It is the responsibility of the application developer to provide proper values.

You can view the available dial_plan and dial_plan_entry fields here

An example syntax is shown below. More information on the dial plan can be found under the section for Dial Plan.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 400<?xml version="1.0" standalone="yes"?> <env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:CreateDialplan> <Domain>localhost</Domain> <Name>test_dp4</Name> <Entry> <Preference>106</Preference> <Trunk>sscs410</Trunk> <Pattern>5*</Pattern> <Replacement>*</Replacement> </Entry> </sns:CreateDialplan> </env:Body> </env:Envelope>`

If the operation is successful, PBX will send back the index of the dial plan entry. Otherwise, PBX will send back zero (0).


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 212<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:CreateDialplanResponse> <Index>24</Index> </sns:CreateDialplanResponse> </env:Body></env:Envelope>`

DeleteDialplan

DeleteDialplan function is a special function to delete the dialplans from the PBX. The <Domain> and <Name> tags are mandatory for DeleteDialplan function. An example syntax is shown below.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 294<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:DeleteDialplan> <Domain>localhost</Domain> <Name>test_dp2</Name> </sns:DeleteDialplan> </env:Body></env:Envelope>`

The response will contain 'true' if the delete successful. Otherwise, the response will contain 'false'.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 195<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:DeleteDialplanResponse> <Ok>true</Ok> </sns:DeleteDialplanResponse> </env:Body></env:Envelope>`

CreateTrunk

CreateTrunk function is a special function to create the trunk in the PBX. The <Domain> and <Name> tags are mandatory for CreateTrunk function. You can also set other parameters while creating the trunk. You can view the available fields/columns for the trunk table here

An example syntax is shown below. More information on the trunks can be found under the section for Trunk Settings.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 400<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:CreateTrunk> <Domain>test1</Domain> <Name>test5</Name> <Type>gateway</Type> <Global>true</Global> <Dir>o</Dir> <Failover>only_5xx</Failover> <Privacy>nohide</Privacy> </sns:CreateTrunk> </env:Body></env:Envelope>`

Please note that some of the trunk fields have fixed values. They are

XML TagDescriptionValues
TypeTrunk typegateway, proxy, register
DirTrunk Directioni, o
FailoverFailover Behaviouralways, never, only_5xx
PrivacyRemote Party/Privacy Indicationpai, rfc3325, nohide, rpi, false
GlobRewrite Global Numbersnanpa, nanpa2, row, plus

If the operation is successful, PBX will send back the index of the created trunk. Otherwise, PBX will send back zero (0).


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 206<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:CreateTrunkResponse> <Index>26</Index> </sns:CreateTrunkResponse> </env:Body></env:Envelope>`

DeleteTrunk

DeleteTrunk function is a special function to delete the trunk from the PBX. The <Domain> and <Name> tags are mandatory for DeleteTrunk function.

File:Note.gif Please remember that all the data configured on the trunk will be lost. So if you have any third party information, please make sure to copy them before deleting the trunk. Also, any association to the dial plans will be removed and all the the dial plan entries related to this trunk will be deleted.

An example syntax is shown below.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 285<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:DeleteTrunk> <Domain>localhost</Domain> <Name>test3</Name> </sns:DeleteTrunk> </env:Body></env:Envelope>`

The response will contain 'true' if the delete successful. Otherwise, the response will contain 'false'.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 202<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:DeleteTrunkResponse> <Ok>true</Ok> </sns:DeleteTrunkResponse> </env:Body></env:Envelope>`

AddCredit

AddCredit API can be used to apply credit to an user / extension. All the tags are mandatory. It is application's responsibility to supply the valid amount in the <Amount> tag. You can provide values like 50.25 (for 50 dollars and 25 cents) or 100 (for 100 dollars).

A sample AddCredit message and the possible responses are shown below.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 309<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:AddCredit> <Extension>622</Extension> <Domain>localhost</Domain> <Amount>50.50</Amount> </sns:AddCredit> </env:Body></env:Envelope>`

On a successful add credit, you will receive the response with <Ok> tag set to 'true' and the new balance in the /<CreditBalance> tag.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 220`


`<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:AddCreditResponse> <Ok>true</Ok> <CreditBalance>100</CreditBalance> </sns:AddCreditResponse> </env:Body></env:Envelope>`

If there was any error in processing the add credit, then you will see the following response with <Ok> tag set to 'false'.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 199<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:AddCreditResponse> <Ok>false</Ok> </sns:AddCreditResponse> </env:Body></env:Envelope>`

GetRegistrations

GetRegistrations API can be used to retrieve the registrations for an user / extension. All the tags are mandatory. It is application's responsibility to supply the valid parameters. A sample AddCredit message and the possible responses are shown below.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 295<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:GetRegistrations> <Extension>45</Extension> <domain>localhost</domain> </sns:GetRegistrations> </env:Body></env:Envelope>`

On a successful GetRegistration, you will receive the response with all the registered user agents. Below is a successful response.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 537<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:GetRegResponse> <Registration> <Type>REGISTER</Type> <Target>43</Target> <Contact>sip:43@127.0.0.1:14722;rinstance=dabdea83085f550e</Contact> <Device>X-Lite release 1100l stamp 47546</Device> </Registration> <Registration> <Type>REGISTER</Type> <Target>43</Target> <Contact>sip:43@192.168.1.145:3465;transport=tcp;line=q2r46xfq</Contact> <Device>snom360/7.3.14</Device> </Registration> </sns:GetRegResponse> </env:Body></env:Envelope>`

If there was any error in processing the get registration, then you will see the following response with <Ok> tag set to 'false'.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 193<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:GetRegResponse> <Ok>false</Ok> </sns:GetRegResponse> </env:Body></env:Envelope>`

CreateDomain

This API will help the admin to create a domain.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 323<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:CreateDomain> <name>pbx3.company.com</name> <alias>another.name</alias> <display>Test domain</display> </sns:CreateDomain> </env:Body></env:Envelope>`

The sample response is below


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 207<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:CreateDomainResponse><Index>6</Index> </sns:CreateDomainResponse> </env:Body></env:Envelope>`

DeleteDomain

This API lets the admin to delete a domain alias or delete the complete domain with all aliases. If the *<Alias>* tag is set to true , then the PBX will just delete the alias. Otherwise, it will delete the complete domain including all aliases.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 300<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:DeleteDomain> <name>starcodetest</name> <Alias>true</Alias> </sns:DeleteDomain> </env:Body></env:Envelope>`

The sample response is below


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 207<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:DeleteDomainResponse> <Index>5</Index> </sns:DeleteDomainResponse> </env:Body></env:Envelope>`

CreateAccount

This API provides a generic mechanism to create accounts in the PBX. All the fields that are shown below are mandatory. You can provide other fields during the account creation too.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 345<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:CreateAccount> <Domain>localhost</Domain> <Type>Hunts</Type> <Name>637</Name> </sns:CreateAccount> </env:Body></env:Envelope>`

The sample response is below.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 210<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:CreateAccountResponse> <Index>67</Index> </sns:CreateAccountResponse> </env:Body></env:Envelope>`

ModifyAccount

This API provides a generic mechanism to modify an already created account. The below example shows how to modify the display name of an hunt group.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 375<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:ModifyAccount> <Domain>localhost</Domain> <Type>Hunts</Type> <Name>637</Name> <Display>SOAP Modify</Display> </sns:ModifyAccount> </env:Body></env:Envelope>`

The response is shown below.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 210<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:ModifyAccountResponse> <Index>67</Index> </sns:ModifyAccountResponse> </env:Body></env:Envelope>`

DeleteAccount

This API allows the administrator to delete any account in the PBX.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 345<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:DeleteAccount> <Domain>localhost</Domain> <Type>Hunts</Type> <Name>637</Name> </sns:DeleteAccount> </env:Body></env:Envelope>`

The response is shown below


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 210<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:DeleteAccountResponse> <Index>67</Index> </sns:DeleteAccountResponse> </env:Body></env:Envelope>`

ScheduleConference

This API provide a mechanism to schedule a user conference from a remote SOAP application. All the parameters are mandatory except *<Date>* , *<Initiate>* and *<Record>* .


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 500<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "><env:Body> <sns:ScheduleConference> <Name>Test1</Name> <Extension>45</Extension> <Domain>localhost</Domain> <Room>78</Room> <Date>11/18/2011</Date> <StartTime>21:00</StartTime> <EndTime>22:00</EndTime> <Participants>42;test@email.com</Participants> <Initiate>true</Initiate> <Record>false</Record> </sns:ScheduleConference> </env:Body></env:Envelope>`

The sample response is below. It returns the index of the scheduled conference (meeting)


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 220<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:ScheduleConferenceResponse> <Index>21</Index> </sns:ScheduleConferenceResponse> </env:Body></env:Envelope>`

ModifyConference

This API allows the moderator to change parameters of an already scheduled conference. It is useful if the moderator wants to change the start time and/or end time of the meeting or wants to change the recording option or change the auto call option or change the participants list etc.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 438<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:ModifyConference> <Id>21</Id> <Extension>45</Extension> <Domain>localhost</Domain> <Room>78</Room> <Participants>42;pradeep.kumar@snom.com</Participants> <Initiate>false</Initiate> </sns:ModifyConference> </env:Body></env:Envelope>`

The sample response is shown below.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 216<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:ModifyConferenceResponse> <Index>23</Index> </sns:ModifyConferenceResponse> </env:Body></env:Envelope>`

DeleteConference


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 310<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:DeleteConference> <Extension>45</Extension> <Domain>localhost</Domain> <Id>20</Id> </sns:DeleteConference> </env:Body></env:Envelope>`

The sample response is shown below


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 216 `


`<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:DeleteConferenceResponse> <Index>23</Index> </sns:DeleteConferenceResponse> </env:Body></env:Envelope>`

SetExtensionParameterRequest

This SOAP API can be used to set the parameters of an already existing extension. Note that the format of this API is slightly different from other APIs. While most other APIs use *<param_name>Value</param_name>* , this API uses <Parameter>Name of the parameter</Parameter> and <Value>Actual value of the parameter</Value> syntax. This is done to accommodate various applications' need. Also note that the extension name must contain the domain part, as in user@domain syntax.

Below is a sample request to change the first name of a extension.


`POST /soap.xml HTTP/1.1Content-Type: application/xmlContent-Length: 360<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "> <env:Body> <sns:SetExtensionParameterRequest> <Extension>43@localhost</Extension> <Parameter>first_name</Parameter> <Value>Jane</Value> </sns:SetExtensionParameterRequest> </env:Body></env:Envelope>`

On a successful execution you will receive the below response


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 222<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:SetExtensionParameterResponse> <Ok>true</Ok> </sns:SetExtensionParameterResponse> </env:Body></env:Envelope>`

If an error occurs, you will see the below response.


`HTTP/1.1 200 OkContent-Type: application/xmlContent-Length: 223<env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) " xmlns:sns="[http://soap.com/pbx](http://soap.com/pbx) "> <env:Body> <sns:SetExtensionParameterResponse> <Ok>false</Ok> </sns:SetExtensionParameterResponse> </env:Body></env:Envelope>`

Abstract Code to access the pbxnsip database

Because the XML/SOAP functionality is platform-independent, the database access to the pbx can be written in any programming/web scripting language. So the following is an abstract code, which serves as a guideline to assist programmers in implementing the database access functionality.


`<?php// Functions that allow reading of the DB interface of the PBX// Default values$dbadr="localhost";$dbport=8080;// Temporary variables for the PHP xml parser$dbparse="";$dbname="";$dbvalue="";$dbdebug=0;// Helper functionfunction pbx_xml_envelope( $action, $req ) {$r = '<?xml version="1.0" standalone="yes"?>';$r .= "\r\n";$r .= '<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sns="http://www.pbxnsip.com/soap/pbx"><env:Body>';$r .= "<sns:$action>";$r .= $req;$r .= "</sns:$action></env:Body></env:Envelope>";return $r;} // pbx_xml_envelope// Another helper function, Escape necessary XML charactersfunction pbx_xml_encode( $t ) {$t = ereg_replace("'", "'", $t);$t = ereg_replace('"', """, $t);$t = ereg_replace("&", "&", $t);$t = ereg_replace("<", "<", $t);$t = ereg_replace(">", ">", $t);return $t; } // pbx_xml_encode// The main exection function, functions pbx_search(), pbx_get(), pbx_set() and pbx_index() uses this function to carry out the SOAP command providedd te pbx_envelope functionfunction pbx_soap( $req ) {global $dbadr, $dbport, $dbdebug, $debug_tbl;$dbhandle = fsockopen($dbadr, $dbport, $errno, $errstr);if (!$dbhandle) { if($dbdebug) {echo "<font color=red>$errstr ($errno)</font><br>\n"; }return false; }$request = "POST /soap.xml HTTP/1.1\r\n";$request .= "Content-Type: application/xml\r\n";$request .= "Content-Length: " . strlen($req) . "\r\n\r\n";$request .= $req;fputs($dbhandle, $request); $data = "";while(!feof($dbhandle)) {$data .= fread($dbhandle, 128);}fclose($dbhandle);$pos = strpos($data,"\r\n\r\n");if($pos != false) {$body = substr($data, $pos);return $body;}} // pbx_soap// XML parser helper function provided by the PHP Zend enginefunction pbx_start_element( $parser, $name, $attrs ) {global $dbparse, $dbdebug, $debug_tbl;if($dbdebug) {echo "Start $dbparse $name<br>";}if($dbparse == "" && strstr($name, ':') == ":ENVELOPE"){$dbparse = "Envelope";} else if($dbparse == "Envelope" && strstr($name, ':') == ":BODY") {$dbparse = "Body";}else if($dbparse == "Body" && strstr($name, ':') == ":DBGETRESPONSE") {$dbparse = "DBGetResponse";}else if($dbparse == "Body" && strstr($name, ':') == ":DBSEARCHRESPONSE") {$dbparse = "DBSearchResponse";}else if($dbparse == "DBGetResponse" && $name == "COLUMN") {$dbparse = "Column";}else if($dbparse == "DBSearchResponse" && $name == "INDEX") {$dbparse = "Index";}else if($dbparse == "Column" && $name == "NAME") {$dbparse = "Name";}else if($dbparse == "Column" && $name == "VALUE") { $dbparse = "Value"; $dbvalue = ""; }else if($dbparse == "Search" && $name == "INDEX") { $dbparse = "Index"; $dbvalue = ""; }} // another XML parser helper function provided by the PHP Zend enginefunction pbx_end_element( $parser, $name ) { global $dbparse, $dbname, $dbvalue, $dbresult, $dbdebug, $debug_tbl; if($dbdebug) {echo "End $dbparse $name<br>";}if($dbparse == "Envelope") {$dbparse = "";}else if($dbparse == "Body") {$dbparse = "Envelope";}else if($dbparse == "DBGetResponse") {$dbparse = "Body";}else if($dbparse == "DBSearchResponse") {$dbparse = "Body";}else if($dbparse == "Column") {if($dbdebug) {echo "<B>Set $dbname=$dbvalue</B><br>";}$dbresult[$dbname] = $dbvalue;$dbparse = "DBGetResponse";$dbname = null;$dbvalue = null;}else if($dbparse == "Index") {if($dbdebug) {echo "Set $dbvalue<br>";}$dbresult[$dbvalue] = $dbvalue;$dbparse = "DBSearchResponse";$dbvalue = null;}else if($dbparse == "Name") {$dbparse = "Column";}else if($dbparse == "Value") {$dbparse = "Column";}else if($dbparse == "Index") {$dbparse = "Search";}} // Yet another XML parser helper function provided by the PHP Zend enginefunction pbx_xml_data( $parser, $data ) {global $dbparse, $dbname, $dbvalue, $dbdebug, $debug_tbl;if($dbdebug){echo "Data $dbparse $data<br>";}if($dbparse == "Name") {$dbname = $data;}else if($dbparse == "Value") {$dbvalue .= htmlentities($data);}else if($dbparse == "Index") {$dbvalue .= htmlentities($data);}} /*** Get a row of the table:* This is one of the "getter" function that uses the pbx_soap() function. * The "$columns" parameter is a basic array where the array value is the column name.*/function pbx_get( $table, $row, $columns, &$result ) {global $dbresult;$dbparse = "";$dbname = "";$dbvalue = "";// Create a request:$req = "<Table>$table</Table>";$req .= "<Index>$row</Index>";foreach($columns as $col) $req .= "<Column><Name>$col</Name></Column>";$content = pbx_soap( pbx_xml_envelope("DBGet", $req) );/*** PHP will expect the following codes, however you may take advantage of the newest functionality provided by PHP. For more information and functionality, please visit http://us.php.net/soap*/$dbresult = array();$xml_parser = xml_parser_create();xml_set_element_handler($xml_parser, "pbx_start_element", "pbx_end_element"); xml_set_character_data_handler($xml_parser, "pbx_xml_data");if( !xml_parse($xml_parser, $content, true) ) { die(sprintf("Get XML error parsing %s: %s at line %d", htmlspecialchars($content), xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser))); } xml_parser_free($xml_parser); $result = $dbresult;} // pbx_get/*** Set a row of the table:* This is one of another "getter" function that uses the pbx_soap() function. * The "$args" parameter is an ASSOCIATIVE array where the array key is is the name of the* column and the array value is the column value. Some programming and/or web scripting * language do not support this. If the case you can not use an associative array, ther solution * is to use TWO (2) arrays with equal length, one being the column name and the other being the * column value. This issue was encountered and solved when trying to migrate from PHP code to * Visual Basic .NET platform. Other programming/scripting language may need extra procedures to * provide this functionality.*/function pbx_set($table, $row, $args ) {global $dbresult, $dbparse, $dbname, $dbvalue;$dbparse = "";$dbname = "";$dbvalue = "";// Create a request:$req = "<Table>$table</Table>";$req .= "<Index>$row</Index>";if(count($args) > 0) {foreach($args as $col => $val) {$req .= "<Column><Name>$col</Name><Value>" . pbx_xml_encode($val) . "</Value></Column>";}}$content = pbx_soap(pbx_xml_envelope("DBSet", $req));return $content;} // pbx_set// Search all matching entries of a table:function pbx_search($table, $max, $skip, $back, $args, &$result) {global $dbresult, $dbparse, $dbname, $dbvalue;$dbparse = "";$dbname = "";$dbvalue = "";// Create a request:$req = "<Table>$table</Table>";if($skip > 0) $req .= "<Skip>$skip</Skip>";if($back) $req .= "<Back>true</Back>";$req .= "<Max>$max</Max>";if(count($args) > 0) {foreach($args as $col => $val) {$req .= "<Column><Name>$col</Name><Value>" . pbx_xml_encode($val) . "</Value></Column>";}}$content = pbx_soap(pbx_xml_envelope("DBSearch", $req), $remote_adr, $remote_port );$dbresult = array();$xml_parser = xml_parser_create();xml_set_element_handler($xml_parser, "pbx_start_element", "pbx_end_element"); xml_set_character_data_handler($xml_parser, "pbx_xml_data");if( !xml_parse($xml_parser, $content, true)){ if( xml_get_error_code($xml_parser) == XML_ERROR_NO_ELEMENTS ) { global $dbadr, $dbport;echo "<FONT COLOR=RED>Error: $dbadr:$dbport may be invalid, please check.</FONT><BR>";} die(sprintf("Search XML error parsing %s: %s at line %d", htmlspecialchars($content), xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser))); } xml_parser_free($xml_parser); $result = $dbresult;} // pbx_search?>-----------------REMARK pbx_address and pbx_port is a proper IP address to the pbx pbx_address may use DNS if the selected programming or web scripting language supports DNS resolvingREMARK It is best practice to use the pbx machines registered IP address or IP name instead of "localhost", this will prevent the pbxnsip software confusion in the long runSTRING pbx_address = "192.168.1.2"INTEGER pbx_port = 80XML_PARSER xml_parserREMARK pbx_xml_envelope( STRING, STRING ) is a helper function to create an XML/SOAP envelopefunction pbx_xml_envelope( PARAM_action, PARAM_request ) { STRING soapsoap ='<?xml version="1.0" standalone="yes"?>' +NEW_LINE/CARRIAGE_RETURN +'<env:Envelopexmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sns="http://www.pbxnsip.com/soap/pbx"><env:Body><sns:PARAM_action>' + PARAM_request + '</sns:PARAMaction></env:Body></env:Envelope>'return soap} // pbx_xml_envelopeREMARK pbx_xml_encode( STRING ) is a helper function which escapes XML characters as required before sending the request to the pbxfunction pbx_xml_encode( PARAM_string ) {PARAM_string = string_replace( "'", "'", PARAM_string )PARAM_string = string_replace( '"', """, PARAM_string )PARAM_string = string_replace( "&", "&", PARAM_string )PARAM_string = string_replace( "<", "<", PARAM_string )PARAM_string = string_replace( ">", ">", PARAM_string )return PARAM_string} // pbx_xml_encodeREMARK pbx_soap( STRING ) is the "execute" function that sends the request to the pbxREMARK note that it uses the two helper functions pbx_soap() and pbx_xml_envelope()function pbx_soap( PARAM_request ) {SOCKET_CONNECTOR pbx_socketSTRING header_requestSTRING requestSTRING responsepbx_socket = socket_connect( pbx_address, pbx_port )header_request ="POST /soap.xml HTTP/1.1" +NEW_LINE/CARRIAGE_RETURN +"Content-Type: application/xml" +NEW_LINE/CARRIAGE_RETURN +"Content-Length: " + STRING_LENGTH(request) +NEW_LINE/CARRIAGE_RETURN +NEW_LINE/CARRIAGE_RETURNrequest = header_request + PARAM_requestdebug_display( "<B>REQUEST</B><BR>" )debug_display( escape_html_characters( request ) + "<BR>" )pbx_socket->send( request )response = pbx_socket->retrieve()pbx_socket->close()debug_display( "<B>RESPONSE</B><BR>" )debug_display( escape_html_characters( response ) + "<BR>" )return response} // pbx_soap REMARK pbx_get( STRING table, INTEGER row, ARRAY_STRING columns ) gets the values (specified by PARAM_columns) at row (specified by PARAM_row) of the table (specified by PARAM_table) using the XML/SOAP DBGet functionREMARK It is preferable and simplifies a programmers job so that columns uses an array where the keys are 0 to maximum value and the values are column names which will return the value of the column names e.g.columns[0] = first_namecolumns[1] = last_namecolumns[2] = display_namefunction pbx_get( PARAM_table, PARAM_row, PARAM_columns ) {ARRAY_STRING result_setSTRING requestSTRING responseREMARK Create a request:request ="<Table>" + PARAM_table + "</Table> <Index>" + PARAM_row + "</Index>"for each argument in PARAM_columns as column_namerequest = request +"<Column><Name>" + column_name + "</Name> </Column>"response = pbx_soap( pbx_xml_envelope( "DBGet", request )debug_display( escape_html_characters( response )result_set = xml_parser->parse( result_set )return result_set} // pbx_getREMARK pbx_set( STRING table, INTEGER row, ARRAY_STRING args ) sets the values (specified by PARAM_args) at row (specified by PARAM_row) of the table (specified by PARAM_table) using the XML/SOAP DBSet functionREMARK It is preferable and simplifies a programmers job so that columns uses an array where the keys are column names and the values are used to set the value in the pbx database e.g.columns[first_name] = "John"columns[last_name] = "Doe"columns[display_name] = "pbxnsip ROCKS!!!"function pbx_set( PARAM_table, PARAM_row, PARAM_args ) { REMARK note that there will be no ARRAY_STRING result_setSTRING requestSTRING responseREMARK Create a request:request ="<Table>" + PARAM_table + "</Table> <Index>" + PARAM_row + "</Index>"for each value in PARAM_args as column_name into column_valuerequest = request + "<Column><Name>" + column_name + "</Name><Value>" + pbx_xml_encode(column_value) + "</Value> </Column>"respone = pbx_soap( pbx_xml_envelope( "DBSet", request ) )debug_display( escape_html_characters( response )REMARK this will only return the index valuereturn response} // pbx_setREMARK pbx_search( STRING table, INTEGER max, INTEGER skip, BOOOLEAN back, ARRAY_STRING args ) searches for the indexes of the row where args (specified by PARAM_args) are found in the table (specified by PARAM_table). REMARK To limit the search to a given number, set the max (specified by PARAM_max) to the desired limits.REMARK To skip over a certain index number, such as start from index no. 10, set the skip (specified by PARAM_skip) to the desired index number.REMARK To search for indexes in a reverse fashion, set the back (specified by PARAM_back) equal to true, otherwise the default is false and it does *NOT* need to be included. REMARK It is preferable and simplifies a programmers job so that columns uses an array where the keys are 0 to maximum value and the values are column names which will return the indexes if found e.g.columns[0] = first_namecolumns[1] = last_namecolumns[2] = display_namefunction pbx_search( PARAM_table, PARAM_max, PARAM_skip, PARAM_back, PARAM_args ){ARRAY_STRING result_setSTRING requestSTRING responseREMARK Create a request:request ="<Table>" + PARAM_table + "</Table>"if( PARAM_skip > 0 ) request = request + "<Skip>" + PARAM_skip + "</Skip>"if( PARAM_back = true )request = request + "<Back>true</Back>"request = request + "<Max>" + PARAM_max + "</Max>"if( has_elements( PARAM_args ) )for each argument in PARAM_args as column_name into column_valuerequest = request + "<Column><Name>" + column_name + "</Name><Value>" + pbx_xml_encode( column_value ) + "</Value> </Column>"response = pbx_soap( pbx_xml_envelope("DBSearch", request )result_set = xml_parser->parse( response )return result_set} // pbx_search`

Example of Tables and respective columns

Note: these are not all the available tables. To identify the table you need to access, look in the snom ONE root directory on your disk (i.e. /usr/local/snomONE on linux or C:\Program Files\snom\snomONE in windows). Each directory which contains xml files is a table.

For example, we assume we are interested in setting the price to 1.11 for the rate with index 2. First we check the content of the xml file from the snom ONE root directory:


`#cat /usr/local/snomONE/rates/2.xml<?xml version="1.0" encoding="utf-8"?><row><name>Germany</name><prefix>01149</prefix><price>1.11</price> <trunk>3</trunk></row>`

The xml is in directory rates, so this will be the Table tag. To know which Name to use, we also look how the xml file. Since we want to change the price value, we must use <Name>price</Name> in the SOAP request. For our example the SOAP request will look like this:


`<?xml version="1.0" standalone="yes"?><env:Envelope xmlns:env="[http://schemas.xmlsoap.org/soap/envelope/](http://schemas.xmlsoap.org/soap/envelope) "xmlns:sns="[http://www.pbxnsip.com/soap/pbx](http://www.pbxnsip.com/soap/pbx) "><env:Body><sns:DBSet><Table>rates</Table><Index>2</Index><Column><Name>price</Name><Value>1.11</Value></Column></sns:DBSet></env:Body></env:Envelope>`

acds

adminagentsdistributionflaggap_timeimkey0key1key2key3
key4key5key6key7key8key9last_statemelodynightrecover_time
redirectsoap_agentsoap_welcomespeed_limittimeoutwavfile0wavfile1wavfile2wavfile3wavfile4
wavfile5wavfile6wavfile7wavfile8wavfile9

adrbook

display_numberdomainfirstnamenumberspeedtypeuser

attendants

admincode_0code_1code_2code_3code_4code_5code_6code_7code_8
code_9completionexcludedflaghangupinput_0input_1input_2input_3input_4
input_5input_6input_7input_8input_9min_digitsname_triggernightoperatorprompt_0
prompt_1prompt_2prompt_3prompt_4prompt_5prompt_6prompt_7prompt_8prompt_9record_code
record_extsecond_langtimeoutverifywavfile

autocallback

activefusernumbertstuser

callingcards

block_cidnum_id

cobjs

idlegfromtossstdwdrdths
dhtrstatetypeisifi1i3i4i5
i6i7iuiadomainlanghistorydiversionloopcmc
prioritytp

legs

refidcidexttrunkreginboundfromtostate
startconnectdigitsstampsymbolcucrcpcdcc
seccodectaplistenersourcerecpicpriostattapi
numberpartyreasonredirecttype

cdr

cacndfftfulsfsrt
tctetstttuy

colines

calltrunktype

conferences

lengthnamepintype

dial_plan

domainnameua

dial_plan_entry

idpatternpreferencereplacementtrunk

domains

area_codecfn_timeoutcode_agent_logincode_agent_logoutcode_banodcode_banoecode_bargecode_bcidd
code_bcidecode_blackcode_cfadcode_cfaecode_cfbdcode_cfbecode_cfndcode_cfne
code_cfrcode_clrvmcode_dnddcode_dndecode_govmcode_intercomcode_listencode_page
code_parkcode_pickupcode_reccode_redialcode_retrievecode_returncode_teachcode_trace
code_transfercode_vmdcode_vmecode_whitecountry_codedefault_dialplandisplaydp
email_fromemail_passemail_smtpemail_userfrom_stylelang_audiolang_toneslang_web
mailbox_escapemax_accountsmax_callsmax_extensionsmax_mb_durationmb_enter_pinmb_pinsizemb_prefix
mb_sizemb_timeoutmohnamepickup_policyrecord_annoucementsoap_extcallto_style
tzvoicemail

domain_alias

domainname

extensions

adminagent_loginanonymousauth_adravailbargeblock_cidbuddiescall_redialcall_return
cellcell_acdcell_huntcell_mwicell_timecfacfbcfncfn_timeoutcfr
dial_plandisplay_namedisturbdndemail_addressemail_missedemail_statusemail_vmailfaxfirst_name
has_namelang_audiolang_weblineslistenlog_registermacmailbox_accessmailbox_escapemb_enable
mb_pinmb_sizemb_timeoutmwiname_usepasswordpass_usedpbodypicturepresence
ptagptypereadingrec_acdrec_extensionrec_externalrec_huntrec_internalteachtz
ua_typevmail_optionvm_indicatorwavnameweb_pass

hoots

displayextmodeperm

hunts

displayflagmelodynightst1_durst1_extst2_durst2_extst3_durst3_ext
st4_extst9_extto_header

ivrnodes

adminmatchmatch_frommatch_tosoap_uriwavfile

lamps

fromnumberstatetouser

messages

commentdurationfilenamefromnewstarturgentuser

mohs

filenamestringtype

regidx

eventreguser

registrations

callidcontactdatedomaindveventfromfuserinstanceparameter
statetotuseruser_agentwww

schedules

emailsendidmoderatornamepinstart

srvflags

allow_extdisplayfriholidaymodemonsatstatesunthu
tuewed

trunks

codecsdial_extensiondomainfailoverfrompatglobalminornameoutbound_proxyprefix
privacyredirectreg_accountreg_displayreg_keepreg_passreg_registrarreg_stunreg_userremote_party
request_timeoutrequirerfcrtpring180send_emailstatustrustedtypeuse_uuiduuid

users

aliasdialog_statedialog_subscribedialog_versiondial_plandomainidparam1param2param3
type

user_alias

domainnameuser