Google Scripts getCalendarsByName to return calendars with similar names

I'd like to perform a function that allows me to interrogate only google calenders that have a particular character in, namely "#".

I know that the function CalendarApp.getCalendarsByName returns an array of calendars, so I was hoping I could use this function along with wildcards to return the calendars I want. I got some advice on using wild cards from here https://productforums.google.com/forum/#!topic/calendar/gmf6ewpjH4g/

Here's the code so far:

function Test() {  

  var pattern = /.*#.*/;

  var calendarsz = CalendarApp.getCalendarsByName(pattern); 

  Logger.log('Found %s matching calendars.', calendarsz.length);

};

But it's returning no calendars at all. Any suggestions on how to use wildcards with this function, or alternative approaches to returning only calendars with particular characters will be appreciated.

edited Nov 22 '18 at 7:26

DaImTo

45.4k1162242

asked Nov 22 '18 at 7:13

David Robinson

add a comment |

I'd like to perform a function that allows me to interrogate only google calenders that have a particular character in, namely "#".

Here's the code so far:

function Test() {  

  var pattern = /.*#.*/;

  var calendarsz = CalendarApp.getCalendarsByName(pattern); 

  Logger.log('Found %s matching calendars.', calendarsz.length);

};

edited Nov 22 '18 at 7:26

DaImTo

45.4k1162242

asked Nov 22 '18 at 7:13

David Robinson

add a comment |

I'd like to perform a function that allows me to interrogate only google calenders that have a particular character in, namely "#".

Here's the code so far:

function Test() {  

  var pattern = /.*#.*/;

  var calendarsz = CalendarApp.getCalendarsByName(pattern); 

  Logger.log('Found %s matching calendars.', calendarsz.length);

};

edited Nov 22 '18 at 7:26

DaImTo

45.4k1162242

asked Nov 22 '18 at 7:13

David Robinson

I'd like to perform a function that allows me to interrogate only google calenders that have a particular character in, namely "#".

Here's the code so far:

function Test() {  

  var pattern = /.*#.*/;

  var calendarsz = CalendarApp.getCalendarsByName(pattern); 

  Logger.log('Found %s matching calendars.', calendarsz.length);

};

google-apps-script google-api google-calendar-api wildcard

edited Nov 22 '18 at 7:26

DaImTo

45.4k1162242

asked Nov 22 '18 at 7:13

David Robinson

edited Nov 22 '18 at 7:26

DaImTo

45.4k1162242

asked Nov 22 '18 at 7:13

David Robinson

edited Nov 22 '18 at 7:26

DaImTo

45.4k1162242

edited Nov 22 '18 at 7:26

DaImTo

45.4k1162242

edited Nov 22 '18 at 7:26

DaImTo

45.4k1162242

asked Nov 22 '18 at 7:13

David Robinson

asked Nov 22 '18 at 7:13

David Robinson

asked Nov 22 '18 at 7:13

David Robinson

add a comment |

1 Answer
1

active

oldest

votes

The getCalendarsByName method does not support searching with wild card

getCalendarsByName(name)

Gets all calendars with a given name that the user owns or is subscribed to. Names are not case-sensitive.

// Gets the public calendar named "US Holidays".

var calendars = CalendarApp.getCalendarsByName('US Holidays');

Logger.log('Found %s matching calendars.', calendars.length);

Parameters

Name - the calendar name

For that matter the Google Calendar API doesn't support it either so that is not going to work at all. You are going to have to download them all and search them locally probably using getAllCalendars

answered Nov 22 '18 at 7:26

DaImTo

45.4k1162242

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53425626%2fgoogle-scripts-getcalendarsbyname-to-return-calendars-with-similar-names%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

The getCalendarsByName method does not support searching with wild card

getCalendarsByName(name)

Gets all calendars with a given name that the user owns or is subscribed to. Names are not case-sensitive.

// Gets the public calendar named "US Holidays".

var calendars = CalendarApp.getCalendarsByName('US Holidays');

Logger.log('Found %s matching calendars.', calendars.length);

Parameters

Name - the calendar name

answered Nov 22 '18 at 7:26

DaImTo

45.4k1162242

add a comment |

The getCalendarsByName method does not support searching with wild card

getCalendarsByName(name)

Gets all calendars with a given name that the user owns or is subscribed to. Names are not case-sensitive.

// Gets the public calendar named "US Holidays".

var calendars = CalendarApp.getCalendarsByName('US Holidays');

Logger.log('Found %s matching calendars.', calendars.length);

Parameters

Name - the calendar name

answered Nov 22 '18 at 7:26

DaImTo

45.4k1162242

add a comment |

The getCalendarsByName method does not support searching with wild card

getCalendarsByName(name)

Gets all calendars with a given name that the user owns or is subscribed to. Names are not case-sensitive.

// Gets the public calendar named "US Holidays".

var calendars = CalendarApp.getCalendarsByName('US Holidays');

Logger.log('Found %s matching calendars.', calendars.length);

Parameters

Name - the calendar name

answered Nov 22 '18 at 7:26

DaImTo

45.4k1162242

The getCalendarsByName method does not support searching with wild card

getCalendarsByName(name)

Gets all calendars with a given name that the user owns or is subscribed to. Names are not case-sensitive.

// Gets the public calendar named "US Holidays".

var calendars = CalendarApp.getCalendarsByName('US Holidays');

Logger.log('Found %s matching calendars.', calendars.length);

Parameters

Name - the calendar name

answered Nov 22 '18 at 7:26

DaImTo

45.4k1162242

answered Nov 22 '18 at 7:26

DaImTo

45.4k1162242

answered Nov 22 '18 at 7:26

DaImTo

45.4k1162242

answered Nov 22 '18 at 7:26

DaImTo

45.4k1162242

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu