community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

smartsheet connector

Meteoroid

Hi @ivoller,

 

I looked into your sample flow and I think that I understood most of it. Could you tell me more about what I need to change if I want to update existing rows (PUT) instead of POST.

 

Thanks,

 

Julien

Quasar

Hi @Juliendu40000 

 

It's very similar to the Add records except we need a BLOB input for a PUT HTTP action. See attached.

 

The only real difference here apart from converting the JSON to BLOB is that we needed to add an ID for the row to be updated.

 

Let me know if there's anything I can help with. Remember that the Download data of the Download Tool will give useful information in the case of failure. Otherwise it just lets you know what was loaded.

 

Same provisos in this flow re API Token and Sheet IDs used.

 

Iain

 

Quasar

@Juliendu40000 

 

Attached is a flow to get all of the sheet, column and row ids

Meteoroid

Hi @ivoller,

 

Thanks for sharing the workflow. I am unable to open it though. Could you please check the file?

 

Thanks,

 

Julien

 

 

Quasar

Hi @Juliendu40000,

 

The workflow downloads and works for me. What error are you getting? What version of Alteryx?

Alteryx Certified Partner

I'm getting a network error when I try to download this. Is the file still working?

 

Will

Meteoroid

 

 

 

This would be really helpful!!

Meteoroid

I was able to successfully download the 'Get SmartSheet Sheet, Column and Row Ids.yxmd' workflow with Microsoft Edge.

I was able to download the Get Smartsheet Sheet, Column and Row Ids workflow by using Firefox.

Labels