Json format equivalent of the map data type

#1

I want the json format equivalent of the map data type which can be upserted to tigergraph. On trying the payload
{​"vertices":{​"MapTesting":{​"tushartrymap":{​"mapOfState":{​"value":{​"red":1,“green”:2}​}​}​}​}​}​
i am getting the error
The payload json value ‘red’ is not valid, expecting “keylist” or “valuelist”

#2

From python,

MAP<STRING,STRING> attribute_name - shall be passed as,

lst_update=[ ]
for idx, value in batch_data.iterrows():
attributes = {}
_primary_id = ’ ’
attributes[‘attribute_name’] = {
“keylist”: [ “key name” ],
“valuelist”: [ “key value” ]
}
lst_update.append((_primary_id,attributes))

# upsert vertices
conn.graphname = graph_name
print("Updated data:"+str(conn.upsertVertices('Graph node name', lst_update)))
#3

@Sudha Can you provide some more details into the issues you’re experiencing?

#4

Hi Jon, I faced the same error reported on this thread. What i have posted in my previous reply is a solution that worked. Its solved!

1 Like
#5

@Sudha Thank You for the quick reply! I didn’t see any errors with your post so it was a bit unclear if you had issues. Glad that you were able to resolve your issue! Thank you for updating the tread!