Problem reading QRS API dataconnection in Python

[DavidFosterVF]

Hi

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?

[NadiaB]

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...

https://www.pythontutorial.net/python-basics/python-raw-strings/#:~:text=In%20Python%2C%20when%20you....

Let us know if it works. 

[DavidFosterVF · Accepted solution]

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.

[NadiaB]

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