List of all workbooks in CSV

[RafV]

Hi

I would like to export a list of all the workbooks where the name starts with "Analysis" but I still got an error..

Can someone help me with the following code:

import pandas as pd 
from seeq import spy
import datetime
import csv

############################
### PARAMETERS TO CONFIG ###
############################
seeq_server_url = ''
#Seeq Access Key
key = ''
pw = ''

############################

# Spy Login
spy.login(url=seeq_server_url, access_key=key, password=pw,ignore_ssl_errors=True)

workbooks = spy.workbooks.search({ 'Name': 'Analysis *' })

for workbook in workbooks:
    print(workbook.Name)

 

 

 

 

 

[Chris Harp]

Instead of:

for workbook in workbooks:
    print(workbook.Name)

try:

print(workbooks["Name"])

[RafV]

Hi Chris,

Thanks for the quick reply, at the moment I just extended the script (see attachment) but have 2 questions / errros (red borders on picture)

1) How can I filter on the Updated At date using spy.workbooks.search?

2) How can I get the id, name, type and .. of each workbook? Current code returns the error: TypeError: string indices must be integers

I notice that the Spy.Search only displays the results of my workbooks. How can I do a search about all workbooks in Seeq? (I'm already an administrator on our Seeq Server)