Google Sheet updated by Wialon Local report - Apps Script

Hello, shalin.lazar !

It's possible to execute report with required table data, but please note this request may be quite heavy (depend on report interval, amount of tables, units) and you can reach limits in system (depend on request frequency).
System Limitations - https://sdk.wialon.com/wiki/en/local/re … its/limits

If you need to get unit last data and position (location), there is other better way :
to execute request search items (units) with required flags.

Search items by property - https://sdk.wialon.com/wiki/en/local/re … arch_items
Data flags  - https://sdk.wialon.com/wiki/en/local/re … ormat/unit

Example,  searching units by name mask "*"
“itemsType”:avl_unit
flags = 1025 : 1  (base flag ) + 1024 (Last message and position) , first 200 elements (from":0,"to":200)

hst-api.wialon.com/wialon/ajax.html?svc=core/search_items&params={"spec":{"itemsType":"avl_unit","propName":"sys_name","propValueMask":"*","sortType":"sys_name"},"force":1,"flags":1025,"from":0,"to":200}}],"flags":0}&sid=0207c58abf39ae543e70b32387

Response (JSON)  returns all units which user has access, for example  "totalItemsCount":777,"indexFrom":0,"indexTo":200

where parameter "lmsg" show the last message with coordinates of last position (then you can check position by Google internal service to get exact Location).

for example , "lmsg":{"t":1441400392,"f":1073741891,"tp":"ud","pos":{"y":50.3382,"x":26.4060666667,"c":0,"z":0,"s":0,"sc":255}

Please note at all API request you need to use DNS platform site, for example (instead 'hst-api.wialon.com') my.local_site.com/wialon/ajax.html....
Also you need to execute POST requests from your script - https://sdk.wialon.com/wiki/en/local/re … /reqformat

Regarding Google Apps Script we cannot suggest you something as we don't know their functions(method), but I can explain a little bit more about authorization into Wialon.

First you need to login via token - https://sdk.wialon.com/wiki/en/local/re … oken/login
https://sdk.wialon.com/wiki/en/local/re … ogin/login

The token you need to receive on special authorization form  where you enter username and password
URL for authorization form  = DNS (platform site) + login.html + additional parameters (optional).

Then you can use this token (72-digital number) in your script

Please note without additional parameters which you can pass in URL , the token will have the default values (see them in table)
https://sdk.wialon.com/wiki/en/local/re … ogin/login

But in you case it's better to pass parameters duration=0 (means infinite token), access_type=-1 (full access token = the same access rights which user has on platform)

If you would like to use JS API, you can find example here  https://sdk.wialon.com/wiki/en/local/js … odesamples
For example, how to work with authorization form / token - https://sdk.wialon.com/playground/demo/app_auth_token
Or Login - https://sdk.wialon.com/playground/demo/login

More about token authorization is here https://weblog.gurtam.com/storage/old_e … hod_EN.pdf

Hi shalin.lazar !

Please find below the required information.

1. Please skip parameter "operateAs" - it needs only when you login under other sub-user.
We will add notes about it in documentation.

2. If there is not SSL certificates for monitoring site, the HTTPS will be not available.
Please request to your provider (or manager) Wialon Local with this issue

3. If the frequency of receiving data is not more than 30 minutes, you can execute request to get report data.
Before you need to create report for unit group,  add table Unit Latest Data (select column), set up option "Addresses from Geofences" in report's settings (in this case if unit is in geofence, the address location will be changed to geofence's name).

After you can execute report, for example -for previous 30 minutes.
( Here is example )

Interval beginning    2021-01-26 08:00:00
Interval end    2021-01-26 08:29:59
Report execution time    2021-01-26 08:30:29

https://hst-api.wialon.com/wialon/ajax.html?svc=report/exec_report&sid=02a11914b29a58aa81c602eed3df0396

{"reportResourceId":930849,"reportTemplateId":6,"reportTemplate":null,"reportObjectId":269,"reportObjectSecId":0,"interval":{"flags":16777344,"from":0,"to":30},"reportObjectIdList":[]}

where "reportResourceId" - resource Id where report template is created
"reportTemplateId" - report template id

"reportObjectId" - unit group id

"interval":{"flags":16777344,"from":0,"to":30} - the values of flags means interval in minutes, "from"/"to" - how much

The response will reserve the report content (tables array, how much rows, grouping level, column names and etc).

Then you need to execute request to get table data - for example use request report/select_result_rows.  It returns JSON that contains rows of all levels.

https://hst-api.wialon.com/wialon/ajax.html?svc=report/select_result_rows&sid=02a11914b29a602eed3df0396&params={"tableIndex":0,"config":{"type":"range","data":{"from":0,"to":5,"level":0,"unitInfo":1}}}

{"tableIndex":0,"config":{"type":"range","data":{"from":0,"to":5,"level":0,"unitInfo":1}}}

"tableIndex":0 - means 1st table in array

"from":0,"to":5 - as in previous request parameters rows: 6 , and level:1

Response

So you will get in parameter "c" : unit name, zone name ("t"), coordinates (x & y)

"c":[
"Renaul di",
{
"t":"Zone3",
"y":50.0035171509,
"x":12.30988324
}
]

Please note if there is not geozones for location, the 't' will contain just address

{
"t":"France, Aube, Neuville-sur-Seine 10250, D 26",
"y":57.079603,
"x":65.233575
}

Hello shalin.lazar !

1. If the error related to Apps Script, unfortunately, we cannot help with this.
When you execute POST request to login into Walon (  for example, https://hst-api.wialon.com/wialon/ajax.html?svc=token/login&params={"token":"2fe8024e0ab91aa6c8ed82717b71bddcECDC362358DF7D90986F5173D405CD0D42DE7B38"}   ), the server will return response in JSON format.

2. To get items id - you can use request searh_items, and search element by name.
Please look example how to find users, the same you can use to find unit, resource, just specify the proper 'itemsType' - avl_unit , avl_resource
https://sdk.wialon.com/wiki/en/local/re … arch_items

Also (some lifehack ) you can open Develop Console in browser, and look which requests  going from Wialon , when do one of the action.
For example report's execution.

Hello shalin.lazar !

No, parameter "eid" is session id, so  your session is 213139c8hcjdkdbfb55f21vff8aa5104
( https://sdk.wialon.com/wiki/en/local/re … n#response )

That is why you get error 1 which means invalid session

Hello!

Not correct value -  "itemsType":"resource"
Correct is  "itemsType":"avl_resource"
Please look here https://sdk.wialon.com/wiki/en/sidebar/ … parameters

Hello Shalin,

By default the data response always at GMT+0
To get response data with required timezone , it needs after login execute request svc=render/set_locale to set up timezone
For example,  GMT+2

https://hst-api.wialon.com/wialon/ajax. … 516e0d6647
params: {"tzOffset":134224928,"language":"en","flags":256,"formatDate":"%m-%E-%Y %H:%M:%S"}

Please note it also need to URL-encoded special characters as % (use %25 instead  %)