Re: stone_validators.ValidationError

Question

Hi Greg,
&nbsp;

def&nbsp;insert_data():
&nbsp;&nbsp;&nbsp;&nbsp;has_more&nbsp;=&nbsp;True
&nbsp;&nbsp;&nbsp;&nbsp;cursor&nbsp;=&nbsp;cnxn.cursor()
&nbsp;&nbsp;&nbsp;&nbsp;while&nbsp;has_more:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;cursor&nbsp;is&nbsp;None:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;entries&nbsp;=&nbsp;dbx.files_list_folder(Dropbox_file,&nbsp;limit=2000).entries
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;entries&nbsp;=&nbsp;dbx.files_list_folder_continue(cursor)

&nbsp; &nbsp; &nbsp; &nbsp;for&nbsp;entry&nbsp;in&nbsp;entries:
...

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cursor&nbsp;=&nbsp;entries.cursor
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Repeat&nbsp;only&nbsp;if&nbsp;there's&nbsp;more&nbsp;to&nbsp;do
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;has_more&nbsp;=&nbsp;entries.has_more
&nbsp;
I'm getting an error with the message&nbsp;
dropbox.stone_validators.ValidationError: '&lt;pyodbc.Cursor object at 0x000002831027A8B0&gt;' expected to be a string, got Cursor
&nbsp;
Can you help me fix this? I'm trying to read more than 2000 files in a single dropbox folder..

Greg-DB · Answer

When using&nbsp;files_list_folder_continue, the cursor you pass in should be the last cursor returned by&nbsp;files_list_folder or files_list_folder_continue. You seem to be correctly saving that cursor via 'cursor = entries.cursor', however you overwrite it via 'cursor = cnxn.cursor()'.
&nbsp;
I don't see where 'cnxn' is defined, but based on the error output you seem to be passing in a "pyodbc.Cursor" object, which seems to be an object from this unrelated&nbsp;pyodbc library. You'll need to fix your code to pass in the&nbsp;Dropbox cursor string, not a pyodbc.Cursor.

mukul04 · Answer

Thanks Greg, I tried doing this and it seems to work!&nbsp; Might be useful as a template while reading more number of files and inseting them to a MySQL dsatabase.&nbsp;&nbsp;#Connect&nbsp;to&nbsp;the&nbsp;SQL&nbsp;databaseimport&nbsp;pyodbc&nbsp;import&nbsp;osimport&nbsp;jsonimport&nbsp;globfrom&nbsp;pathlib&nbsp;import&nbsp;Path&nbsp;import&nbsp;datetime&nbsp;as&nbsp;dt&nbsp;import&nbsp;stringimport&nbsp;dropbox#Connect&nbsp;to&nbsp;the&nbsp;DBcnxn&nbsp;=&nbsp;pyodbc.connect('Driver={SQL&nbsp;Server};Server=;Database=;Trusted_Connection=yes;')&nbsp;print("Connection&nbsp;established")cnxn.timeout&nbsp;=&nbsp;60cnxn.autocommit&nbsp;=&nbsp;Truecursor&nbsp;=&nbsp;cnxn.cursor()dbx&nbsp;=&nbsp;dropbox.Dropbox("")result&nbsp;=&nbsp;dbx.files_list_folder("",&nbsp;recursive=True,&nbsp;include_deleted=False,&nbsp;include_media_info=False)def&nbsp;process_entries(entries):&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;entry&nbsp;in&nbsp;entries:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;isinstance(entry,&nbsp;dropbox.files.FileMetadata):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#print(entry.name)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;md,&nbsp;res&nbsp;=&nbsp;dbx.files_download(entry.path_lower)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;json_obj&nbsp;=&nbsp;json.loads(res.content)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;al_data&nbsp;=&nbsp;json.dumps(json_obj)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#Insert&nbsp;values&nbsp;into&nbsp;the&nbsp;DB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cursor.execute("INSERT&nbsp;INTO&nbsp;dbo.audiolink_table_1&nbsp;(...)&nbsp;process_entries(result.entries)&nbsp;#&nbsp;Check&nbsp;if&nbsp;there&nbsp;are&nbsp;more&nbsp;files&nbsp;in&nbsp;the&nbsp;folderwhile&nbsp;result.has_more:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;result&nbsp;=&nbsp;dbx.files_list_folder_continue(result.cursor)&nbsp;&nbsp;&nbsp;&nbsp;process_entries(result.entries)&nbsp;

Forum Discussion

Re: stone_validators.ValidationError

2 Replies

About Dropbox API Support & Feedback

Related Content

stone_validators.ValidationError

Online-only files are re-downloading automatically

re

Re: Dropbox commiting fraud, can't cancel business team service

Re-setting up Sync

Recent Discussions

/oauth2/authorize (code flow) redirects to http://www.dropbox.com/home instead of redirect_uri

Add id and .tag fields to DeletedMetadata in the API

Shared Link - Download in .NET

Dropbox API server root certificate changes for .Net

GetCurrentAccountAsync API Failing for some Team Members while using Impersonation