GetDatabases
This is the method that you are using
| | Parameters | See configuration table above | | Result Type |List of Records
Indicates that the method can return a list rather than a single record
| | Record Limit | 10 | | Record JsonPath |Each method returns data in JSON format. To pick any specific information from the JSON, we need to specify the Record JsonPath so that the iX Hello platform will pick that data in consideration while displaying results.
Example: $.\[\*]
This selects all the records that are returned.
| | Empty Result Template |Sorry, no database found in the given server. How else can I help you?
Note:
Anything written in between {{ }} is represented as a JSON field and is case-sensitive.
| | Result Template |Here are the databases found {{Records}}. How else can I help you?
{{Records}} represents that the record template is going to loop around all the items in the list.
| | Record Template |{{DatabaseName}}
Note:
Anything written in between {{ }} is represented as a JSON field and is case-sensitive and derived from the result obtained from the method.
It represents a single record of the list.
| Below is a sample response format – You should get response like this. ```json [ {"DatabaseName":"database1"}, {"DatabaseName":"Instance2"}, ] ``` You can test whether the method has been created correctly by clicking on Test on the action menu. The object screen shall display all the values that are being retrieved from the method while the Result tab presents how the output will be presented to the user.GetTables
The method you are using
| | Parameters | See configuration table above | | Result Type |List of Records
It indicates that the method can return a list of records rather than a single record
| | Record Limit | 10 | | Record JsonPath |Each method returns data in JSON format. To extract any specific information from the JSON, we need to specify the Record JsonPath so that the iX Hello platform will choose that data while displaying results.
Example: $.\[\*]
This selects all the records returned.
| | Empty Result Template |No tables created for {{Input.DatabaseName}}. How else can I help you?
Note:
Anything written in between {{ }} is represented as a JSON field and is case-sensitive. {{Input.DatabaseName}} represents that it is replaced by whatever value is provided by user input. For example, if the input parameter name was providerName, the field should be set as {{Input.providerName}}.
| | Result Template |Here are the tables found {{Records}}. How else can I help you?
{{Records}} represents that the record template is going to loop around all the items in the list.
| | Record Template |{{TableName}}
Note:
Anything written in between {{ }} is represented as a JSON field and is case-sensitive and derived from the result obtained from the method.
This represents a single record from the list.
|GetAllItems
The method used.
| | Parameters | See configuration table above. | | Result Type |List of Records
It indicates that the method can a list of records rather than a single record.
| | Record Limit | 10 | | Record JsonPath |Each method returns data in JSON format. To pick any specific information from the JSON, we need to specify the Record JsonPath so that the iX Hello platform will pick that data when displaying results.
Example: $.\[\*]
This selects all the records returned.
| | Empty Result Template |No tables created for {{Input.TableName}}. How else can I help you?
Note:
Anything written in between {{ }} is represented as a JSON field and is case-sensitive. {{Input.TableName}} represents that it is replaced by whatever value is provided by user input. For example, if the input parameter name was providerName, it should be entered as {{Input.providerName}}.
| | Result Template |Here are the details found {{Records}}. How else can I help you?
{{Records}} represents that the record template is going to loop around all items in the list.
| | Record Template |{{FirstName}}
Note:
Anything written in between {{ }} is represented as a JSON field and is case-sensitive and derived from the result obtained from the method. It should be the field name in the table.
It represents the single record of the list.
| Sample Response:[
{
"Productid": "1",
"Name": "Smart Watch",
"Price": "100",
},
{
"Productid": "2",
"Price": "50",
"Name": "Product A"
}
]
GetItem
The method used
| | Parameters | See configuration table above | | Result Type |Record
Indicates that the method returns a single record rather than a list of records.
| | Record JsonPath |Each method returns data in JSON format. To extract any specific information from the JSON, we need to specify the Record JsonPath so that the iX Hello platform will pick that data while displaying results.
Example: $.\[\*]
This selects all the records that is returned.
| | Empty Result Template |No data found for {{Input.TableName}}. How else can I help you?
Note:
Anything written in between {{ }} is represented as a JSON field and is case-sensitive. {{Input.TableName}} represents that it is replaced by whatever value is provided by the user in input. For example, if the input parameter name was providerName, it shall have been used as {{Input.providerName}}.
| | Result Template |Here are the details found {{Name}}. How else can I help you?
{{Records}} represents that the record template is going to loop through all the items in the list.
| Sample Response: ```json { "Productid": "1", "Name": "Smart Watch", "Price": "100", } ``` Here there is only one matching record. If there are multiple records, you will get multiple items in the JSON array. ### Method: PostItem Parameters: | Parameter | Sample Value | Info | | ----------------- | ------------------------------------ | ------------------------------- | | TableName | Product | SQL Server database table name. | | PartitionKeyName | Productid | Name of the Partition Key | | PartitionKeyValue | 1 | Value for the Partition Key | | ItemData | {"Name": "Smart Watch","Price": 100} | Item data in JSON format | Sample Response:| Parameter | Sample Value | Info |
|---|---|---|
| TableName | Product | SQL Server database table name. |
| ItemData | { "Name": "Smart Watch", "Price": 100 } | Item data in JSON format |
| Parameter | Sample Value | Info |
|---|---|---|
| TableName | Product | SQL Server database table name. |
| PartitionKeyName | Productid | Name of the Partition Key |
| PartitionKeyValue | 1 | Value for the Partition Key |
| ItemData | { "Name": "Smart Watch 2", "Price": 111 } | Item data in JSON format |
[
{
"ProductId": 1,
"Name": "Smart Watch"
},
{
"ProductId": 2,
"Name": "Product A"
}
]