Web

Formats

The Web Connector allows to get data from RESTful Web Services that serve JSON content.

The response content is expected with the following format only :

{
  "TableA": [
    {  // data record 1 for TableA
      "FieldA1": "ValueA1_1",
      "FieldA2": "ValueA2_1",
      ...
    },
    {  // data record 2 for TableA
      "FieldA1": "ValueA1_2",
      "FieldA2": "ValueA2_2",
      ...
    },
    {  // data record 3 for TableA
      "FieldA1": "ValueA1_3",
      "FieldA2": "ValueA2_3",
      ...
    },
    ...
  ],
  "TableB": [
    {  // data record 1 for TableB
      "FieldB1": "ValueB1_1",
      "FieldB2": "ValueB2_1",
      ...
    },
    ...
  ],
  ...
}

Selecting Connection Type

In the “Create Connection” dialog change the Connection “Type” by selecting “Web” :

Connection Parameters

URL

Enter the API URL which must be a valid REST API as seen above.

Authentication Type

Select the authentication to use :

• “No Authentication”
• “Basic HTTP Authentication” : with User name and Password
  

Connection Schema

The Web Connection presents first level object lists as tables to be used in a Data Source.

In the example above, it will list “Table1”, “TableB”, …

Data refresh and Buffer

The Web Connector is bufferized.

If you need to get new data, see Chapter The data Buffer

Code192 2020 All rights reserved