Skip to main content

Hey, I have a problem with Monday API version 10 in python. Since it changed on February 15, mine python code doesn’t work anymore. The error is shown at this part of the code. Maybe you now how to fix this problem?:


.q_columns =

‘{boards(limit:10000 state:all) {id name state owner{id} columns {id title type}}}’

data_columns = {‘query’: q_columns}

r_columns = requests.post(url=apiUrl, json=data_columns,

headers=headers)

columns_json = r_columns.json()

df_columns = pd.DataFrame(columns_jsonl‘data’]o‘boards’])

df_columns.head()

it show this error: JSONDecodeError Traceback (most recent call last)

File C:\\ProgramData\\Anaconda3\\lib\\site-packages\\requests\\models.py:910, in Response.json(self, **kwargs)

909 try:

→ 910 return complexjson.loads(self.text, **kwargs)

911 except JSONDecodeError as e:

912 # Catch JSON-related errors and raise as requests.JSONDecodeError

913 # This aliases json.JSONDecodeError and simplejson.JSONDecodeError


File C:\\ProgramData\\Anaconda3\\lib\\json_init_.py:346, in loads(s, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)

343 if (cls is None and object_hook is None and

344 parse_int is None and parse_float is None and

345 parse_constant is None and object_pairs_hook is None and not kw):

→ 346 return _default_decoder.decode(s)

347 if cls is None:


File C:\\ProgramData\\Anaconda3\\lib\\json\\decoder.py:337, in JSONDecoder.decode(self, s, _w)

333 “”“Return the Python representation of s (a str instance

334 containing a JSON document).

335

336 “””

→ 337 obj, end = self.raw_decode(s, idx=_w(s, 0).end())

338 end = _w(s, end).end()


File C:\\ProgramData\\Anaconda3\\lib\\json\\decoder.py:355, in JSONDecoder.raw_decode(self, s, idx)

354 except StopIteration as err:

→ 355 raise JSONDecodeError(“Expecting value”, s, err.value) from None

356 return obj, end


JSONDecodeError: Expecting value: line 1 column 1 (char 0)


During handling of the above exception, another exception occurred:


JSONDecodeError Traceback (most recent call last)

Input In a7], in <cell line: 6>()

3 data_columns = {‘query’: q_columns}

4 r_columns = requests.post(url=apiUrl, json=data_columns,

5 headers=headers)

----> 6 columns_json = r_columns.json()

7 df_columns = pd.DataFrame(columns_json ‘data’]t‘boards’])

8 df_columns.head()


File C:\\ProgramData\\Anaconda3\\lib\\site-packages\\requests\\models.py:917, in Response.json(self, **kwargs)

915 raise RequestsJSONDecodeError(e.message)

916 else:

→ 917 raise RequestsJSONDecodeError(e.msg, e.doc, e.pos)


JSONDecodeError: Errno Expecting value] upstream request timeout: 0


Reply