Re: BAC 8.03 OpenAPI Query - User Question (216 Views)
Reply
Super Advisor
Michele Ruggiero
Posts: 362
Registered: ‎04-11-2008
Message 1 of 4 (216 Views)
Accepted Solution

BAC 8.03 OpenAPI Query - User Question

Hi All,
I created an OpenAPI query and I have this question:
- Can I use in the webquery an user different by an user which administration privileges? If "yes" which permission I have to allow to this user?
Thanks
Michele
Please use plain text.
Honored Contributor
Amit Erental
Posts: 1,128
Registered: ‎07-05-2009
Message 2 of 4 (216 Views)

Re: BAC 8.03 OpenAPI Query - User Question

Hi Michele

Page 298 of the solutions and integrations pdf :

Permissions
For a query to access the data using the API query syntax described below,
the user and password parameters passed in the query must be those of a
user with either System Viewer or Superuser permissions. For details on
setting permissions in the Permissions Manager, see â Permissions Overviewâ
in Platform Administration.

Please use plain text.
Super Advisor
Michele Ruggiero
Posts: 362
Registered: ‎04-11-2008
Message 3 of 4 (216 Views)

Re: BAC 8.03 OpenAPI Query - User Question

Hi Amit, thanks for your support.
With system_viewer permission I solved the user problem.
Now I have another problem. Using the query I observed a very strange thing. Time_stamp field(express in long seconds) is not aligned with bac_system_date. Pratically if I use in the select:

time_stamp>=1283328000 that in GMT+1 is time_stamp>=01/09/2010 09:00:00

bac give me as result (also in custom query builder) values with time_stamp>=01/09/2010 10:00:00 as follow:

time_stamp Target Name Measurement Name
Measurement Value

9/1/10 10:00 AM xyxyxyxy Volumi 8.00.

BAC_DB, BAC_GW and BAC_DPS have the same date (in GMT+1).
I don't know why bac has different values for time_stamp in date format and in log-seconds format.
Do you know how is managed this values by bac?
Thanks in advance
Michele

Please use plain text.
Honored Contributor
Amit Erental
Posts: 1,128
Registered: ‎07-05-2009
Message 4 of 4 (216 Views)

Re: BAC 8.03 OpenAPI Query - User Question

HI Michele

Not sure I totally understood the question

The query uses and returnes time in seconds since january 1 , 1970. this number is always in UTC (which is GMT without time zone offset and without DST offset)

So if you query for time > some_number, and this number represent 09:00 on GMT, you will get result that match this query, which also match 10:00 in GMT + 1

For the date format:

For logs, BAC uses date format as specified in the log properties files

How did you get this output "9/1/10 10:00 AM xyxyxyxy Volumi 8.00" ? took the web response to excel or some other editor?

Try to have a look at the integration and solutions pdf, for "Date-Time Values" and "byTime Function" (pages 304-305), or for dateFormat parameter (page 310), if you are using Legacy Queries

Hope this help

Amit



Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation