Sign in to join the conversation:
Can I integrate a sheet with my bank (Lloyds) to automatically download new statement lines every 30 mins or so. I have to login to my bank and copy the data across all the time and would like to automate it if possible.
Hi Tom,
It mainly depends on your bank. Is it possible to access the data from the bank through an API or similar?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Thanks for your response Andree. I new to this. What is an API, and how can I tell if they have one?
Happy to help!
They do have an API but I don't know what's possible with it. Do you have any option to email the transactions on a regular basis instead?
More info about the API: https://developer.lloydsbank.com/opendata-v2.2#get-personal-current-accounts-2.2
I hope that helps!
I have just recently found use cases where I needed Bridge. I created a sheet with unpivotted data. I have a love/hate relationship with the tool for now. I really like flexibility and power, what I don't like is how difficult it is to troubleshoot and in some ways manage the workflows. Seems to be some sensitive points…
raise HttpError(rex, "SSL handshake error, old CA bundle or old OpenSSL?") from rex smartsheet.exceptions.HttpError: (SSLError(MaxRetryError("HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded with url: /2.0/sheets (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED]…
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…
