Upload CSV files automatically to KoboToolBox Media Files

[Kal_Lam]

Welcome to the community, @andis! Maybe these posts discussed previously should help you solve your issue:

Using API to upload media files?

@Josh It works beautifully! Many thanks. I did some experimenting and I found that ODK will download the new CSV file if you sync manually, even if you don’t redeploy the form. Here’s the final python script for anyone who wants to programmatically upload the CSV file for pulldata purposes: import requests import json KC_URL = 'https://<kc_url>/api/v1/' KF_URL = 'https://<kf_url>/api/v2/' TOKEN = '<token>' XFORM = <xform_id> FILE_FOLDER = r"<file_folder>" …

and …

How to replace csv media file or delete existing media file using kobo v2 API

Okay @Kal_Lam, please find below the developed Python script that does the following Deletes a media file (input.csv) Uploads a new media file (input.csv) Redeploy form to display the newly uploaded media file. The script: import requests, json URL = 'https://<url>/api/v2/' TOKEN = '<token>' XFORM = '<form_id>' headers = {'Authorization': f'Token {TOKEN}'} #### TO DELETE OLD MEDIA FILE try: data_url = "%sassets/%s/files/" % (URL, XFORM) response = requests.get(data_url, headers=h…