selectNumber

Purpose

Runs an SQL SELECT query on the server and returns the first element of the results as a decimal number.

HTTP Method

GET

URL

https://app.infiniteblue.com/rest/api/selectNumber

URL Parameters

sessionId

The session ID obtained from the body of the response when calling login.

output

Optional parameter specifying the output format, one of: xml (default) or json.

query

A text pattern to search.

Permissions Required

View permission for the requested object type.

Response

Query result as decimal number

Example

Output: first element returned by query converted into number and wrapped in XML. Example: 

<?xml version="1.0" encoding="UTF-8"?>
        <resp status="ok">
        <value>53</value>
        </resp>

Output example in JSON:

{ "value": 53.0 }