Skip to main content

Updating Change_Column_Value: TypeError Issue

  • October 16, 2019
  • 2 replies
  • 1521 views

Hi - I am kinda new to GraphQL and I am trying to write a code that will update a column in my board with data from a .csv file saved to my drive. I tried running the code but get this error message:
TypeError: not all arguments converted during string formatting

Code:
for index, row in dataframe.iterrows():
Availability = str(row[‘Availability’]).replace(“,”, “”)
item_id = str(row[‘ID’])
mutation = ‘’’
mutation {
change_column_value(board_id: 309020018, item_id: 309020024, column_id: “Availability”, value: “"500"”) {
id
}
}
‘’’ % (item_id)
print(mutation)
result = client.execute(mutation)
print (result)

I would love any feedback that can be provided! Thanks!

This topic has been closed for replies.

2 replies

dipro
Forum|alt.badge.img
  • Leader
  • October 25, 2019

Hey Angela, thanks for writing here! Welcome 🙂 I’ld love to know more.

Do you get the TypeError from your Python interpreter, or from our API? I’m unfamiliar with this error being thrown by our API but I’m happy to take a look.


  • Community Expert
  • July 10, 2020

Hello, @ABAngela. As far as I understand, this is an error from Python interpreter.

Answer to this issue might help to understand it python - Why do I get "TypeError: not all arguments converted during string formatting" trying to substitute a placeholder like {0} using %? - Stack Overflow