topic Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV in Digital Exchange

SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

harish.mogulluri — Fri, 03 Dec 2021 14:04:42 GMT

Hello,

I'm using Smartsheet API and able to use other Actions Available in Smartsheet - Sheet Actions VBO and able to use different actions but having issue using Get sheet as CSV action. After I use the action the csv file is not storing in my local based on the Smartsheet Document it will send the output as Output Stream But there is no output parameter in Get Sheet as CSV action and file is not storing on my local is there a way I can store the file by passing path as input variable?

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

ewilson — Fri, 03 Dec 2021 15:18:18 GMT

@Harish Mogulluri,

The value in the Response_Content data item is the actual CSV content. You can use the Utility - File Management VBO to write that content out to a file.

Cheers,

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

harish.mogulluri — Fri, 03 Dec 2021 15:30:12 GMT

Thanks @Eric.

Yes I noticed that but basically I want to get highlighted colors in smartsheet as well . If I use the response content I may loose the highlighted cells just trying to figure out how to get the highlighted color.

Just to give some context basically We created a formula if some body updated the sheet from the past 24 hours the smartsheet will highlight the updated cells.

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

ewilson — Fri, 03 Dec 2021 15:46:53 GMT

@Harish Mogulluri,

If you want to include the special formatting of a sheet then you shouldn't be getting it as a CSV. CSV is typically just the actual content of a sheet, not it's formatting. To preserve formatting you'd need to get the sheet as an XLSX or PDF.

If you want to try getting the sheet in a different format you can change the value of the Accept header on the request. For XLSX, you'd set the header value to application/vnd.ms-excel. For PDF, you'd set the value to application/pdf.

Cheers,
Eric

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

harish.mogulluri — Fri, 03 Dec 2021 16:10:14 GMT

Yes I tried changing that header yesterday but the file is not saving on my local.

Thanks,
Harish

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

harish.mogulluri — Fri, 03 Dec 2021 16:17:31 GMT

Do you think parsing the response content and updating to xlsx using file management or any other way will get the desired result. I will check this anyway

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

ewilson — Fri, 03 Dec 2021 16:20:02 GMT

@Harish Mogulluri,

Ah yes, that's an issue with the Web API feature. The XLSX and PDF files are binary content which the Web API feature doesn't properly support. There's a enhancement request open with product to address this.

In the meantime there is a workaround. It involves using the Utility - HTTP VBO to perform this one action. Here are some screenshots of a quick test I performed.

Cheers,
Eric

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

harish.mogulluri — Fri, 03 Dec 2021 17:14:33 GMT

Thanks for your response . I dont see HTTP Request file action . I'm using BP 6.10.2 version. Is this VBO updated in Version 7?

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

ewilson — Fri, 03 Dec 2021 17:23:04 GMT

You can get the latest version of the Utility - HTTP VBO from the DX.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/utility---http

Cheers,
Eric

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

harish.mogulluri — Fri, 03 Dec 2021 18:00:37 GMT

Thank you Eric That worked. I tried using C# code earlier to save the file using Smartsheet DLL but some reason I'm getting an error and closing BP itself.

Re: SmartSheet API Connector from Digital Exchange - Having issue with Get sheet as CSV

Pralay — Thu, 09 May 2024 17:49:15 GMT

Hi,

I am new to use smartsheet automation in our project. Can you please help me how to automate in BP. I got one release file from digital exchange but I tried to import in Release/Skill, it is navigating to import release file but after importing i am not able to find this release file in BP studio. Given below is the release file. Is this bellow file is helpful to automate smartsheet?

Can you please how to automate SmartSheet - Inserting, updating, deleting data functionality

Thanks,

Pralay