Knowledge Base - Cloud Connect

Run a queryType Procedure

This functionality is used to retrieve a number from a number series. The value for the "numberseries" parameter determines the number series that is used for retrieving a number.

  1. In Swagger, navigate to the Experlogix Integration API.

  2. In the Query endpoints, access the getValue endpoint.

  3. In the upper right corner, select Try It Out.

  4. In the connectionId field, add the connection ID.

  5. In the query definition field, add the following code.

    {
       "name": "firstfree",
       "entity": "0",
       "skip": 0,
       "take": 10,
       "queryType": "Procedure",
       "queryText": "getfirstfreenumber",
       "columns": [
       ],
       "filters": [
       ],
       "parameters": [{
             "name": "numberseries",
             "valueType": "String",
             "parameterType": "Input",
             "value": "S-ORD"
           }
        ]
    }
    
  6. Select Execute.

    BC-QueryFirstFreeQuery.png

The response displays a new number from S-ORD series.

BC-ResponseFirstFreeQuery.png