Com'X > Excel Web Query

[enrgyautomation]

Hello!

Is it possible to pull data into MS Excel from a Com'X via Web Query?

Thanks.

[Romain_Polette]

Hello @Randi_Dolan 

I up this topic because I have the same request from a customer.

For EGX300 it was possible to put logged data into .xls file using a Web Query : "/stream/devlog_data.html?device=x"

Is it possible to do the same with ComX510 ?

Or do we need put some scripts on a Web Server as explained in the topic : ComX510 data Export via HTTP or HTTPS

Thanks.

Romain

[Randi_Dolan]

Hi,

The Com'X uses an HTTP POST to send log data.  So, it is not an easy task to setup Excel to get log data from the Com'X.  However, after doing a brief web search, I see that you can use VBA to perform the post.  So, if this is something that you would like to explore further, please let me know and I will get more information about the POST details.

Thanks,

Randi

[Romain_Polette]

Hello Randi, 

Thanks for your answer. 

Regards.

Romain