Issue ingesting RAW datatype column using PyRFC

Question

I'm running into an issue dealing with RAW datatype column when pulling data from SAP using PyRFC.

Below is the screenshot of the metadata and how the data looks in SAP GUI.

Below is the snippet of the code I'm running to pull this column.

with Connection(user=user, passwd=password, ashost=host, sysnr=sysnr, client=client) as connObj:
    dataObj = connObj.call(table)
    print dataObj

    for x in dataObj.get('PT_LIST'):
        print "type: ", type(x["PARENT"])
        print "parent: ", x["PARENT"]

I'm getting the following response for print dataObj.

{u'PT_LIST': [{u'PARENT': '\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00'}, {u'PARENT': '\xa06\x9f\xa8\\\xb4\x1e\xda\xac\x97\x18-\xf5\xb4\x1f\xe8'}]}

type:  <type 'str'>
parent:
type:  <type 'str'>
parent:  ▒6▒▒\▒ڬ▒-▒▒

and when I try to convert it to str, I'm getting the following error.

Traceback (most recent call last):
  File "<stdin>", line 18, in <module>
UnicodeDecodeError: 'ascii' codec can't decode byte 0xa0 in position 0: ordinal not in range(128)

Could someone please help me understand how to properly convert this data to a readable format the same as how it shows in SAP GUI.

Appreciate your time and response.

Thanks,

Answer 1

I've modified my code as below which worked like magic. Special thanks to @Sandra Rossi for the suggestions.

with Connection(user=user, passwd=password, ashost=host, sysnr=sysnr, client=client) as connObj:
    dataObj = connObj.call(table)
    for x in dataObj.get('PT_LIST'):
        print "parent: ", x["PARENT"].encode('hex')

Output:

parent:  00000000000000000000000000000000
parent:  a0369fa85cb41edaac97182df5b41fe8

encode('hex') did the trick. I've been trying utf-8 and other encodings while I should be using hex in this case.