Advertisement
retnet

doGet json spreadsheet

Aug 7th, 2023
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.85 KB | None | 0 0
  1. function doGet(e) {
  2. var op = e.parameter.action;
  3. var ss = SpreadsheetApp.openById("spreadsheet_id");
  4. if (op == "getconfig")
  5. return get_config(e, ss);
  6. }
  7. function get_config(e,ss) {
  8. var sheet = ss.getSheetByName("Sheet1");
  9. var paket = e.parameter.paket;
  10. var flag = 0;
  11. var lr = sheet.getLastRow();
  12. for (var i = 1; i <= lr; i++) {
  13. var pkt = sheet.getRange(i, 5).getValue();
  14. if (pkt == paket){
  15. var urlapk = sheet.getRange(i, 3).getValue();
  16. var versiapp = sheet.getRange(i, 4).getValue();
  17. var personaads = sheet.getRange(i, 6).getValue();
  18. var judulnya = sheet.getRange(i, 7).getValue();
  19. var keterangannya = sheet.getRange(i, 8).getValue();
  20. var gambariklannya = sheet.getRange(i, 9).getValue();
  21. var linkpsnya = sheet.getRange(i, 10).getValue();
  22. var appid = sheet.getRange(i, 11).getValue();
  23. var banner = sheet.getRange(i, 12).getValue();
  24. var interstitial = sheet.getRange(i, 13).getValue();
  25. var nativeads = sheet.getRange(i, 14).getValue();
  26. var ngitungklik = sheet.getRange(i, 15).getValue();
  27. var result = JSON.stringify({
  28. "myads": {
  29. "urlapk": urlapk,
  30. "versiapp": versiapp,
  31. "personaads": personaads,
  32. "judulnya": judulnya,
  33. "keterangannya": keterangannya,
  34. "gambariklannya": gambariklannya,
  35. "linkpsnya": linkpsnya,
  36. "appid": appid,
  37. "banner": banner,
  38. "interstitial": interstitial,
  39. "nativeads": nativeads,
  40. "ngitungklik": ngitungklik
  41. }
  42. });
  43. flag = 1;
  44. }
  45. }
  46. if (flag == 0){
  47. var result = "gagal";
  48. }
  49. return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JAVASCRIPT);
  50. }
  51.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement