how can i get data into excel through web services

Connectivity
Connectivity covers the mechanisms for connecting to the Teradata Database, including driver connectivity via JDBC or ODBC.
Scout

how can i get data into excel through web services

Hi,

I have a requirement that i need to get teradata table data into excel through web services/ REST API. Is there any feasibilty to do the same?

1 REPLY 1
Highlighted
Teradata Employee

Re: how can i get data into excel through web services

Hi rkp1916,

 

With a quick search for VBA REST AP I found this : 

https://github.com/VBA-tools/VBA-Web/releases

 

Note I don't know it (neither VBA), but it seems to worth a try.

 

If it doesn't work, you'll have to use your favorite programming language (R, Python, C, Java, et cetera) and write something.

For instance in Python it's not that difficult using packages pandas and request.