Hi @Alejandro-juarez22 ,
I might be easier if you add any issues with this specific automation to the comments of the automation template, that way others encountering similar issues will be able to see.
From other comments in that thread, this issue is often caused by double quote (") or backslash characters (\) existing in your source table.
I can see that you have quotes “ in your source table. This breaks the formatting of the request that we send to excel which looks like this “Value1”,”Value2”. The quotes encapsulate each string and help to ensure the comma acts as a delimiter between cells. Having quotes in your data breaks this expected formatting and the Excel API doesn’t know what to do with the request.
Hi @Alejandro-juarez22 ,
I might be easier if you add any issues with this specific automation to the comments of the automation template, that way others encountering similar issues will be able to see.
From other comments in that thread, this issue is often caused by double quote (") or backslash characters (\) existing in your source table.
I can see that you have quotes “ in your source table. This breaks the formatting of the request that we send to excel which looks like this “Value1”,”Value2”. The quotes encapsulate each string and help to ensure the comma acts as a delimiter between cells. Having quotes in your data breaks this expected formatting and the Excel API doesn’t know what to do with the request.