gsheets inserting python dictonary using batchupdate

Question

I am new to gheets and am looking for a way to insert the data that I have scraped into gheets that is currently in a python dictionary. I would like to do this in a batch process so my spider can update multiple fields at once.

{'page_url': 'https://www.websiteurl.com', 'company': 'my company', 'location': 'The Netherlands',
                  'price_excl_vat': '30000'}

I tried to build a json request but am getting TypeError: unhashable type: 'dict'. I know its because the data field takes a string but thought qould be able to take a dictionary and cant seem to find how to do thie. Been at this all day and just cant seem to figure out what I am doing wrong.

batch_update_spreadsheet_request_body =  {

    {
     "requests": [
      {
       "insertRange": {
        "range": {
         "sheetId": '12345tutu',

        },
       }
      },
      {
       "pasteData": {
        "data":  {'page_url': 'https://www.websiteurl.com', 'company': 'my company', 'location': 'The Netherlands',
                  'price_excl_vat': '30000'},

       }
      }
     ]
    }

}

request = service.spreadsheets().batchUpdate(spreadsheetId=spreadsheet_id, body=batch_update_spreadsheet_request_body)
response = request.execute()

score 0 · Accepted Answer · answered Dec 06 '18 at 02:54

0

You should remove a pair of {}:

batch_update_spreadsheet_request_body = {
     "requests": [
      {
       "insertRange": {
        "range": {
         "sheetId": '12345tutu',

        },
       }
      },
      {
       "pasteData": {
        "data":  {'page_url': 'https://www.websiteurl.com', 'company': 'my company', 'location': 'The Netherlands',
                  'price_excl_vat': '30000'},

       }
      }
     ]
    }

It creates a set containing a dictionnary, and that is not possible, because as the error says, sets elements have to be hashable, and a dict is not.

answered Dec 06 '18 at 02:54

Axel Puig

1,304
9
19

From where? I have tried removing it from the data but the : gives an error. The thing is I need to map this to the correct column. – dcarlo56ave Dec 06 '18 at 03:02
You have to remove the external braces. It works on my computer, check the code of my answer. – Axel Puig Dec 06 '18 at 03:07
– dcarlo56ave Dec 06 '18 at 03:21
Ive check the sheetID and spreadsheet id and these are also the fields that are in the spreadsheet. I dont get why I am now getting a 400 error – dcarlo56ave Dec 06 '18 at 03:25
OK, so your first problem is solved. You are talking about another issue, which is not a python but a ggsheet API issue. – Axel Puig Dec 06 '18 at 03:30

gsheets inserting python dictonary using batchupdate

1 Answers1