Problem with Python Script since Monday

  • SeaTable Cloud Plus

Since Monday (yesterday), a external Python script has been aborting when attempting to perform an SQL query on a table.
However, I can’t find anything that indicates that something needs to be changed in my script because of version 5.3.
This part of the script:

base = Base(token, server)
base.auth() #Connection works correct

stext = 'select mail_id,_id from DF_Emailextern where mailid = '+str(m_id)
qdata = base.query(stext) <<<<-----

It aborts on this line with reference to "base.query"

The error message (in VSC):
Exception has occurred: MissingSchema
Invalid URL ‘/api/v1/query/03e907ff-12e0-410f-abab-9cf69dcdd563/’: No scheme supplied. Perhaps you meant https:///api/v1/query/03e907ff-12e0-410f-abab-9cf69dcdd563/?

I can’t figure out what’s wrong.
Best regards from Cologne

Hi @Max,
This is weird :thinking:… As far as I understand you launch this script from VSC, right ? Maybe you should try to look at the seatable-api library version you’re actually using: I tried with v3.0.0 and didn’t encounter the problem.

Bests,
Benjamin

1 Like

Hello Benjamin,
Yes, that’s exactly what it was. I had that idea too, but didn’t pursue it any further.
After updating the library, the query works again. I still have a problem converting the date format in the script, but I’m getting that resolved.
Many thanks and best regards from Cologne

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.