iCube
  • iCube Learning
  • Introduction
    • What is iCube?
  • iCube Platform
    • iCube Server
      • Overview
      • Data
        • Value & Value Relation editor
          • Query Data
          • Add Data
          • Update Data
          • Delete Data
      • Tag
        • What is Tag?
          • Tag configuration
            • Create Tag
            • Update Tag
            • Delete Tag
        • What is TagRelation?
          • TagRelation configuration
            • Create TagRelation
            • Update TagRelation
            • Delete TagRelation
      • Interface
        • Interface configuration
          • Create Interface
          • Update Interface
          • Delete Interface
        • Mapping configuration
          • Create Mapping
          • Update Mapping
          • Delete Mapping
      • Integration
        • Provider
          • [Integration Provider] API Document
            • Get service list all
            • Get connection
            • Get Tag all
            • Get Tag Relation all
            • Get Tag by name
            • Get Tag Relation by name
            • Get single Tag value
            • Get single Tag Relation value
            • Get multiple Tag values
            • Get multiple Tag Relation values
            • Get multiple Tag values (with Body)
            • Get multiple Tag Relation values (with Body)
            • Insert multiple Tag values
            • Insert multiple Tag Relation values
            • Update multiple Tag value
            • Update multiple Tag Relation value
            • Delete multiple Tag values
            • Delete multiple Tag Relation values
          • APIs Document
            • Get service lists
            • Get connection
            • Get tags
            • Get tagrelations
            • Get tag by tagname
            • Get tagrelation by tagrelation name
            • Get single tag value
            • Get single tagrelation value
            • Get multiple tags values
            • Get multiple tagrelations values
            • Get multiple tags values (with Body)
            • Get multiple tagrelations values (with Body)
            • Insert multiple tag values
            • Insert multiple tagrelation values
            • Update multiple tag values
            • Update multiple tagrelation values
        • Publisher
          • Create Publisher
          • Update Publisher
          • Delete Publisher
      • Scheduling
        • Create Schedule
        • Update Schedule
        • Delete Schedule
      • Security
        • User configuration
          • Create User
          • Update User
          • Delete User
        • Role & Permission configuration
          • Create Role
          • Update Role
          • Delete Role
        • Token provider configuration
          • Create Token
          • Delete Token
    • iCube Form
      • Overview
        • Create Group
        • Manage Group
        • Setting Group
        • Delete Group
      • Form
        • Create Form
        • Setting Form
        • Design
          • Input
          • Editor
          • Card
          • Date Form
          • Table
          • Submit Button
          • Navigate
          • Signature
          • Drop Down
          • Upload file
          • Custom graphic
        • Duplicate Form
        • Delete Form
      • Workflow
        • Task
        • Request
          • Action
          • Create Request
        • Flow Template
          • Create Flow Template
          • Update Flow Template
          • Delete Flow Template
        • Workflow history
      • History
        • Form
      • Upload
      • Security
        • User
        • Role Permission
        • Menu Permission
    • Power BI Connector
      • Download & Install
      • Setting Options Security
  • iCube API
    • Overview of Resource URL Patterns
      • Get Connection
      • Get Tag all
      • Get Tag Relation all
      • Get Tag detail
      • Get Tag Relation detail
      • Get single Tag value
      • Get single Tag Relation value
      • Get multiple Tag values
      • Get multiple Tag Relation values
      • Get multiple Tag values (with Body)
      • Get multiple Tag Relation values (with Body)
      • Insert multiple Tag values
      • Insert multiple Tag Relation values
      • Update single/multiple Tag value
      • Update single/multiple Tag Relation value
      • Delete multiple Tag values
      • Delete multiple Tag Relation values
Powered by GitBook
On this page
Export as PDF
  1. iCube Platform
  2. iCube Server
  3. Integration
  4. Provider
  5. [Integration Provider] API Document

Get single Tag Relation value

Fetches the values of a specific tag relation identified by its name, along with optional filters for time range and conditions.

Example URL

https://api.icube.co.th/integration/webapi/tagrelation/bronze_relation_raw/value?starttime=*-10d&endtime=*&query=name like 'K%'

Last Update: 5 NOV 2024

Retrieve Tag Relation Value with Conditions

Method: GET

URL: {{base_url}}/tagrelation/{tagrelationname}/value?starttime={starttime}&endtime={endtime}&query={query}


Query Parameters:

Parameter
Required
Description

starttime

Yes

Starting time for filtering the data (e.g., *-10y) (Default: starttime=*-10m)

endtime

Yes

Ending time for filtering the data (e.g., *) (Default: endtime=*)

query

No

A condition to filter the results, acting like a WHERE clause in PostgreSQL.

Time Expression:

Expression
Description

sec

Second

m

Minute

h

Hour

d

Day

mo

Month

y

Year

*

Present

-

Go back (e.g., *-10d means go back 10 days)

+

Go forward (e.g., *+10mo means go forward 10 months)


Response Example:

{
    "data": [
        {
            "Id": "string",
            "name": "string",
            "tel": "string",
            "quality": integer,
            "status": integer,
            "timeStamp": "datetime"
        }
    ]
}

Note: The fields Id, name, and tel are placeholders and will vary depending on the specific tag relation being represented in the request. Ensure you refer to the specific tag relation schema for exact field details.

Response Details:

Object
Data Type
Description

data

array

Array of tag relation value objects returned from the API.

Id

string

Unique identifier for the tag relation.

name

string

Name associated with the tag relation.

tel

string

Telephone number associated with the tag relation.

quality

integer

Quality indicator of the tag relation value.

status

integer

Status code associated with the tag relation value.

timeStamp

datetime

Timestamp when the tag relation value was recorded.

PreviousGet single Tag valueNextGet multiple Tag values

Last updated 6 months ago