Hello,
I am from a non technical background, i wrote a code in app script to add a row in my poshest AppSheet Audit Log shows this error -
Action Details
Email Details
REST API:
{
โActionโ: โโActionโ is missing.โ,
โPropertiesโ: {},
โRowsโ:
}
Properties:
{
โRestAPIVersionโ: 2,
โTableNameโ: โAPIBOTโ,
โAppTemplateVersionโ: โ1.001222โ,
โErrorsโ: โโActionโ is missing.โ,
โAppTemplateNameโ: โ4d0e346f-17c7-4b2b-bf84-20***6983ca6โ,
โOperationโ: โREST API invokeโ,
โRecordTypeโ: โStartโ,
โResultโ: โFailureโ
}
Here is my app script codeโ
function myFunction() {
let data = {
โActionโ: โAddโ,
โPropertiesโ: {
โLocaleโ: โen-INโ,
โLocationโ: โ47.623098, -122.330184โ,
โTimezoneโ: โPacific Standard Timeโ,
โUserSettingsโ: {
โOption 1โ: โvalue1โ,
โOption 2โ: โvalue2โ
}
},
โRowsโ: [
{
โCOUNT1โ: โ1โ
}
]
};
const params = {
โmethodโ: โPOSTโ,
โpayloadโ: JSON.stringify(data),
}
const res = UrlFetchApp.fetch(โhttps://api.appsheet.com/api/v2/apps/4d6f-17c7-4b2b-bf84-200c3ca6/tables/APIBOT/Action?applicationAccessKey=V2-oK**s-9hthE-5nGku-GXjrq-erleI-S****-E7J04-t0hdIโ, ****ms)
// CONST res = UrlFetchApp.fetch(โURL Fetch Service | Apps Script | Google Developersโ);
Logger.log(res.getContentText());
}
It will be a great help if someone can correct my code
Can someone please reply this.
This isnโt a Google Apps Scripts forum, so you canโt expect much help in that regards.
I donโt see any glaring issues with your code, but it is also incredible hard to read in the format that you have posted, Iโd advise utilizing markdown to make it easier to read.
User | Count |
---|---|
42 | |
32 | |
24 | |
23 | |
14 |