For ex:
i have below data in gsheet:
oppID status date
789 active 20/12/24
123 active 20/12/24
456 inactive 21/12/24
Now if a user want to update oppid 123 as inactive. how to do that dynamically?
i don't want to fetch whole data from gsheet and check in which row the oppid is. Is there any search mechanism i can have to directly search in gsheet and update the row
2 Antworten
Shekh Muenuddeen (NTTData) 
Forum Ambassador
As per me there are two ways to do it
- Using MuleSoft DataWeave - download excel , load into DataWeave and update row then DataWeave output will excel file and upload excel file.
Read - Excel file
%dw 2.0
var myInput = readUrl("classpath://ourBugs.xlsx", "application/xlsx")
output application/json
---
myInput."Data"
Generate Excel file
%dw 2.0
output application/xlsx header=true
---
{
Data: payload
}
- Read excel file using java or other scripting language which MuleSoft Supports. Using this way it might be easy to update excel file.
Example
https://dzone.com/articles/how-to-color-excel-file-using-mulesoft-1