Differences

This shows you the differences between two versions of the page.

--- power_bi_connector:faqs [2022/08/16 13:14] – su
+++ power_bi_connector:faqs [2024/01/31 14:21] (current) – su
@@ Line 19: / Line 19: @@
 \\
 This should remove any existing credentials and allow you to log in again.
+----
 =====How do I modify my query to use parameters?=====
@@ Line 39: / Line 41: @@
 {{:power_bi_connector:power_bi_-_changing_parameters.png?400|}}
+----
 =====How do I fill out the "Get" queries?=====
-**Get Data**
-| Name || Required || Type || Description || Default || Example ||
-| Tag Name(s) || true || string || Comma separated tag names to get data for. || n/a || Sinusoid,LIC040 ||
-| Start Date || true || string || Absolute or relative start time to use when performing the data query. || n/a || *-10d, 2018-01-15 ||
-| End Date || true || string || Absolute or relative end time to use when performing the data query. || n/a || *, *-1h, 2020-09-01T00:00:00 ||
-| Function || true || option || Data function/aggregation to use when performing data query. || n/a || Interp, Plot, Min, Max, Avg, Raw ||
-| Interval|| false || string || The sample interval. || n/a || 20s, 3h, 1d ||
-| Number of Points || false || number || The maximum number of points to return per tag. Takes precedence over the Interval parameter if both specified. || n/a || 10, 150 ||
-| Display || false || option || Indicate whether to display numerical, string or both tag values. Some tags (digital) might indicate a status which has a more meaningful text value, e.g.OFF, representation than a numerical value, e.g. 0. || Numeric ||  ||
 **Get Processed**
@@ Line 87: / Line 81: @@
 | Tag Name(s) || true || string || Comma separated tag names to get data for. || n/a || Sinusoid,LIC040 ||
 | Display || false || option || Indicate whether to display numerical, string or both tag values. Some tags (digital) might indicate a status which has a more meaningful text value, e.g.OFF, representation than a numerical value, e.g. 0. || Numeric ||  ||
+**Get Data**
+**Please note - "Get Data" is part of our legacy API. We highly recommend using the "Get Processed" and "Get Plot" functions instead**
+| Name || Required || Type || Description || Default || Example ||
+| Tag Name(s) || true || string || Comma separated tag names to get data for. || n/a || Sinusoid,LIC040 ||
+| Start Date || true || string || Absolute or relative start time to use when performing the data query. || n/a || *-10d, 2018-01-15 ||
+| End Date || true || string || Absolute or relative end time to use when performing the data query. || n/a || *, *-1h, 2020-09-01T00:00:00 ||
+| Function || true || option || Data function/aggregation to use when performing data query. || n/a || Interp, Plot, Min, Max, Avg, Raw ||
+| Interval|| false || string || The sample interval. || n/a || 20s, 3h, 1d ||
+| Number of Points || false || number || The maximum number of points to return per tag. Takes precedence over the Interval parameter if both specified. || n/a || 10, 150 ||
+| Display || false || option || Indicate whether to display numerical, string or both tag values. Some tags (digital) might indicate a status which has a more meaningful text value, e.g. OFF, representation than a numerical value, e.g. 0. || Numeric ||  ||
+----
 =====What is the difference between using "Get Raw" compared to "Get Data" - Function = "Raw"?=====
 There is no difference between these two approaches in terms of the data it returns. "Get Raw" is part of our newer API where we have separated out the types of queries as they each have different inputs. The "Get Data" is our legacy API which contains them all in a single endpoint.
+----
+=====How do time zones work with the Industrial Connector?=====
+The Industrial Connector requires that the user specify UTC timestamps when absolute query timestamps (such as a start date of 2023-04-12T00:00, for example) are used.
+Time zones can be ignored when using relative times (e.g. "*-20m", "*-7d")
+----
 ===== Contact support =====
 If any of the aforementioned issues persist, feel free to [[https://www.intelligentplant.com/contact-us | get in touch with us]].