drompono

Hey there, I´ve got a running workflow that searches through all my documents on my Paperless-ngx Server, via a python script with requests and the paperless API. Most of the workflow is just shameless copied from this great tutorial here, and it is working without problems. Just one thing I can´t search for documents that have Umlaute like Ü,Ä etc. which makes this workflow almost useless for my german pdf documents Does anybody know how to fix this? I tried things like sys.argv[1].encode() or # encoding: utf-8 from __future__ import unicode_literals at the top, but without success. In the API documentation it says the search query must be like /api/documents/?query=your%20search%20query, so I guess I need to encode the sys.argv[1] somewhere in the script? Thanks in advance, here is my script so far: import sys import requests import json # Retrieve user input from Alfred search_query = sys.argv[1] api_key = 'APIKEY' # URL für die Abfrage der Aufgaben url = "https://paperless.XYZ.synology.me/api/documents/?query=" + search_query # HTTP-Header mit API-Schlüssel headers = { 'Authorization': f'Basic {api_key}', 'Content-Type': 'application/x-www-form-urlencoded' } # GET-Anfrage an API stellen response = requests.get(url, headers=headers).json() def get_formatted_results(search_results): formatted_results = [] for item in search_results["results"]: result = { "title": item["title"], "subtitle": item["id"], "arg": item["id"], "autocomplete": item["id"], "icon": { "path": "./icon.png" } } formatted_results.append(result) return formatted_results def get_alfred_items(search_results): if len(search_results["results"]) == 0: result = { "title": "Keine Dokumente gefunden.", "subtitle": "Versuche eine neue Suche", } return [result] else: return get_formatted_results(search_results) if __name__ == "__main__": # Make API call to fetch the npm search results and assign it to a variable npm_search_results = requests.get(url, headers=headers).json() # A Script Filter is required to return an items array of zero or more items. # Each item describes a result row displayed in Alfred. alfred_json = json.dumps({ "items": get_alfred_items(npm_search_results) }, indent=2) # Pass the formatted JSON data back to Alfred sys.stdout.write(alfred_json)

thanks! items.append({ 'title': d['content'], 'subtitle': datetime.fromtimestamp(d['creationDate']).strftime('%d.%m.%y - %H:%M'), 'arg': d['localkey'] })

Fantastic! Thats working! One last question, the modificationDate in subtitle are in Unix Timestamp like 1587040951.0199919 - How can I convert them to %d.%m.% - %H:%M ?

Hi! Im using Simplenote and found out there is a CLI available. Now I want to create a workflow to search through my notes. I´m just starting to use the Script Filter more and still I don´t know how I can use json output from the cli to display the results in alfred. If I type something with the Script Filter: /usr/local/bin/sncli -n export {query} debugging shows me: ERROR: Simplenote Search[Script Filter] Unable to decode JSON results, top level type is not dictionary in JSON: [ { "tags": [], "deleted": false, "shareURL": "", "publishURL": "", "content": "gmail", "systemTags": [ "markdown" ], "modificationDate": 1599312951.145001, "creationDate": 1569875316, "key": "XXX", "version": 58, "syncdate": 1600667523.891809, "localkey": "XXX", "savedate": 1602487240.5917828 }, { "tags": [], "deleted": 0, "shareURL": "", "publishURL": "", "content": "gmail 2", "systemTags": [ "markdown" ], "modificationDate": 1587040951.0199919, "creationDate": 1587031436.520257, "key": "XXX", "version": 23, "syncdate": 1587154334.194783, "localkey": "XXX", "savedate": 1602487240.5917828 } ] How is it possible to create an item for each search result, for example with title: content, subtitle: creationDate, argument: localkey?

ah ok seems the edit in Numbers App changed the seperators from , to ; so I changed for row in csv.DictReader(fp, delimiter=';'): but now I get this error: [18:02:26.322] ERROR: Search Shopify CSV[Script Filter] Code 1: [fuzzy] . [fuzzy] cmd=['/usr/bin/python', 'fuzzylist.py'], query='', session_id=None [fuzzy] running command ['/usr/bin/python', 'fuzzylist.py'] ... Traceback (most recent call last): File "fuzzylist.py", line 51, in <module> convert(INFILE, OUTFILE) File "fuzzylist.py", line 37, in convert 'title': ITEM_TITLE.format(**row), UnicodeEncodeError: 'ascii' codec can't encode character u'\u2019' in position 8: ordinal not in range(128) Traceback (most recent call last): File "./fuzzy.py", line 380, in <module> main() File "./fuzzy.py", line 367, in main fb = cache.load() File "./fuzzy.py", line 301, in load js = check_output(self.cmd) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/subprocess.py", line 223, in check_output raise CalledProcessError(retcode, cmd, output=output) subprocess.CalledProcessError: Command '['/usr/bin/python', 'fuzzylist.py']' returned non-zero exit status 1 Do I have to add .decode ascii somewhere? Sorry for all the questions

yes thats it! Thank you very much, thats exactly what I was looking for! Ok I will check what will be better for filterung the results One last question, I replaced the dummy csv with my actual csv list, which is much more lager. I deleted the .json file and triggered the workflow, but then I get this error here: [17:26:11.560] ERROR: Search Shopify CSV[Script Filter] Code 1: [fuzzy] . [fuzzy] cmd=['/usr/bin/python', 'fuzzylist.py'], query='', session_id=None [fuzzy] running command ['/usr/bin/python', 'fuzzylist.py'] ... Traceback (most recent call last): File "fuzzylist.py", line 51, in <module> convert(INFILE, OUTFILE) File "fuzzylist.py", line 37, in convert 'title': ITEM_TITLE.format(**row), KeyError: 'shipping_address_name' Traceback (most recent call last): File "./fuzzy.py", line 380, in <module> main() File "./fuzzy.py", line 367, in main fb = cache.load() File "./fuzzy.py", line 301, in load js = check_output(self.cmd) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/subprocess.py", line 223, in check_output raise CalledProcessError(retcode, cmd, output=output) subprocess.CalledProcessError: Command '['/usr/bin/python', 'fuzzylist.py']' returned non-zero exit status 1 do you know what could be the reason? some fields are empty or have "(", ä, or other special signs included - could that be the cause?

Thanks nfor your quick reply! Ah ok, sorry here the link to my actual workflow: https://dsc.cloud/93b597/Search-Shopify-CSV the included .csv file has 14 rows - row with the fieldname "shipping_address.name" and "total_price" should appear in the alfred json title, "shipping_address.city" and "shipping_address.country" should appear in the subtitle - But If I do a search from Alfred all rows should be included, so if Im searching for an email address, the email row should be searched - is this possible? So should I just add to the for row in reader row['title'] = row['shipping_address.name'] + row['total_price'] or something like this?

Hey there! Im using the fuzzylist workflow template to display results from an .csv file, this here is the fuzzylist.py: #!/usr/bin/python from __future__ import print_function theFile="test.csv" fieldnames=["title","arg","subtitle"] json_filename = theFile.split(".")[0]+".json" import csv import sys import json import os def convert(csv_filename, json_filename, fieldnames): f=open(csv_filename, 'r') csv_reader = csv.DictReader(f,fieldnames, restkey=None, restval=None) jsonf = open(json_filename,'w') jsonf.write('{"items":[') data="" for r in csv_reader: r['uid']=r['arg'] data = data+json.dumps(r)+",\n" jsonf.write(data[:-2]) jsonf.write(']}') f.close() jsonf.close() if (not os.path.isfile(json_filename)) or (os.path.getmtime(theFile) > os.path.getmtime(json_filename)) : convert(theFile, json_filename, fieldnames) with open(json_filename, 'r') as fin: print(fin.read(), end="") it works fine if I have only three rows in the csv file, but what I want is to write the json file like this: {"items": [ { "title": row[1] + ' ' + row[2], "subtitle": row[4]+row[5]+ row[6] } } ]} For example if I have 6 rows in my csv file, I want to display row 1 and row2 together in the search result title. Im sure it belongs somewhere at data = data+json.dumps(r)+",\n" but Im not good in Python programming, so I dont know how to add this lines. Can somebody help?