Forum Discussion

mukul04's avatar
mukul04
New member | Level 2
6 years ago

Re: stone_validators.ValidationError

Hi Greg,   def insert_data():     has_more = True     cursor = cnxn.cursor()     while has_more:         if cursor is None:             entries = dbx.files_list_folder(Dropbox_file, l...
API
Greg-DB's avatar
Greg-DB
Icon for Dropbox Community Moderator rankDropbox Community Moderator
6 years ago

When using files_list_folder_continue, the cursor you pass in should be the last cursor returned by 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()'.

 

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 pyodbc library. You'll need to fix your code to pass in the Dropbox cursor string, not a pyodbc.Cursor.

  • mukul04's avatar
    mukul04
    New member | Level 2
    6 years ago

    Thanks Greg, I tried doing this and it seems to work!  Might be useful as a template while reading more number of files and inseting them to a MySQL dsatabase. 

     

    #Connect to the SQL database
    import pyodbc 
    import os
    import json
    import glob
    from pathlib import Path 
    import datetime as dt 
    import string
    import dropbox

    #Connect to the DB
    cnxn = pyodbc.connect('Driver={SQL Server};Server=;Database=;Trusted_Connection=yes;') 
    print("Connection established")
    cnxn.timeout = 60
    cnxn.autocommit = True
    cursor = cnxn.cursor()
    dbx = dropbox.Dropbox("")
    result = dbx.files_list_folder("", recursive=True, include_deleted=False, include_media_info=False)

    def process_entries(entries):
        for entry in entries:
            if isinstance(entry, dropbox.files.FileMetadata):
                #print(entry.name)
                md, res = dbx.files_download(entry.path_lower)
                json_obj = json.loads(res.content)
                al_data = json.dumps(json_obj)
                .
                .
                .
                
                #Insert values into the DB         
                cursor.execute("INSERT INTO dbo.audiolink_table_1 (...) 
    process_entries(result.entries)
     
    # Check if there are more files in the folder
    while result.has_more: 
        result = dbx.files_list_folder_continue(result.cursor)
        process_entries(result.entries)
     

About Dropbox API Support & Feedback

Node avatar for Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!