topic Re: Problem reading QRS API dataconnection in Python in Integration, Extension & APIs

Problem reading QRS API dataconnection in Python

DavidFosterVF — Fri, 20 May 2022 07:34:31 GMT

In Python, I am struggling to print out the connectionstring value of a dataconnection. I think the problem is that the connection strings are full of brackets and commas, making python interpret it as json structure not values.

Any suggestions how I can python to read the connectionstring as a simple value?

Re: Problem reading QRS API dataconnection in Python

NadiaB — Wed, 25 May 2022 21:07:37 GMT

Hi @DavidFosterVF

I'm not python expert but according to this post it would be r Prefix:

https://stackoverflow.com/questions/4703516/how-to-write-string-literals-in-python-without-having-to-escape-them

https://www.pythontutorial.net/python-basics/python-raw-strings/#:~:text=In%20Python%2C%20when%20you%20prefix,(%20%5C%20)%20as%20literal%20characters.

Let us know if it works.

Re: Problem reading QRS API dataconnection in Python

DavidFosterVF — Thu, 26 May 2022 07:35:52 GMT

Turned out i should be using the json.loads (i.e. load string) which reads the json into a python dictionary and the connectionstring was correctly read as a single value.

Re: Problem reading QRS API dataconnection in Python

NadiaB — Wed, 01 Jun 2022 20:13:33 GMT

Thanks for sharing the resolution @DavidFosterVF for the python code issue.