artitionKey.get(part) AttributeError: 'str' object has no attribute 'get'

Mahesh K 1

I am reading csv using pandas pd.read_csv method...and then loading the data to cosmos db:

without converting the df to json obj...it is generating error saying 'wrong obj passed'...then i used json.dumps(data_dict) to convert it to json obj...but now it is saying below error:

return self._retrieve_partition_key(partition_key_parts, document, is_system_key)
File "C:\ProgramData\Anaconda3\lib\site-packages\azure\cosmos_cosmos_client_connection.py", line 2539, in _retrieve_partition_key
partitionKey = partitionKey.get(part)
AttributeError: 'str' object has no attribute 'get' 97900-csv-to-cosmos.txt

KalyanChanumolu-MSFT 8,336 Reputation points

2021-05-20T06:36:25.43+00:00

@Mahesh K Could you please check if you are able to parse the csv file correctly?

use print(df.to_string()) and check if all the columns are converted correctly.
Mahesh Katla 1 Reputation point

2021-05-21T10:18:46.52+00:00

Yes it is converting ...problem is python json.dumps(dicts)..converting the keys of the json also string.

Any idea which fun can help us in converting it into perfect json obj...or cosmos db expected json obj format.

Share via

artitionKey.get(part) AttributeError: 'str' object has no attribute 'get'

Your answer