v3/workflows/{workflowid}/versions error

[craigja]

Im using the API to try and update a version of a workflow (migrating it from Dev to Production) but for the life of me I cant see what Im doing wrong!  Ive filled in all the required fields (see the screenshot) but still get an error: v3/workflows/{workflowid}/versions missing required Query Parameter.  I've also confirmed that all the parameters are filled in, Im also using them when uploading a new workflow and it works fine

[alexnajm]

I am sure you are following this article - so double check that everything is met, for example the media type being a .yxzp!

[craigja]

Yep I have read that article and confirmed im entering everything required.  Im using the Alteryx API and it also shows (you can see this in the screenshot) that all required information is populated (Ive also double checked the fields and confirmed there is correct information in each one, and the same information is being used if the workflow is new and this works fine).  I cannot see what I am missing :-(  It also seems I'm not the first to have this issue:https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Missing-required-query-paramet...

[alexnajm]

Yeah definitely seems like a recurring issue! Are you getting any errors similar to the other thread? Or just the one in your original post?

I'd say regardless if we can help or not, submit it as a case so that Alteryx Support is aware / can help

[craigja]

Yeah, I pretty much get the same error:

Server API (151) Tool #698: Traceback (most recent call last): ¶ File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\pandas\core\indexes\range.py", line 413, in get_loc ¶ return self._range.index(new_key) ¶ValueError: 0 is not in range ¶ ¶The above exception was the direct cause of the following exception: ¶ ¶Traceback (most recent call last): ¶ File "C:\Users\craigj\AppData\Local\Temp\Engine_10020_39db77dd1a894a2f8db94eb601da8c3a_\0c4751a66f01df721dd889c72b67d2f2\workbook.py", line 154, in <module> ¶ baseUrl = inputDF.baseURL[0] ¶ File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\pandas\core\series.py", line 1111, in __getitem__ ¶ return self._get_value(key) ¶ File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\pandas\core\series.py", line 1227, in _get_value ¶ loc = self.index.get_loc(label) ¶ File "C:\Program Files\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\pandas\core\indexes\range.py", line 415, in get_loc ¶ raise KeyError(key) from err ¶KeyError: 0 ¶

[alexnajm]

Maybe it's the version of the Server API tool you are using? Honestly I am not sure - I think Alteryx Support is your best route!

[apathetichell]

This is only on uploading a version of a workflow to an existing workflow on prod? can you confirm that there are values in all the fields? and can you throw a blank payload in? like {}?

I'd also recommend testing your parameters on postman.

[craigja · Accepted solution]

Ive finally fixed the issue - its a strange one!  If you have more than the required fields in the input to the API, when using versions endpoint, it gives you this error.  Thats how I solved it - put a select before the input to the API and select only the fields that are required, confirmed if I add more fields in, it falls over again

[apathetichell]

@craigja-> fascinating! sound like bad python -> like they mapped the column by location in the DF vs assigning a column name. That might explain the .iloc error you posted.