Smartsheet Bridge special characters not encoding in endpoint URL

Has anyone ran into this issue?

I would like to parse an ISO formatted time into the endpoint URL, but it's not encoding "+" to %2B.

My particular use case is getting the latest CVEs from Vulnerability APIs (nist.gov)

The endpoint should be formatted as such:

https://services.nvd.nist.gov/rest/json/cves/2.0/?lastModStartDate=2021-08-04T13:00:00.000%2B01:00&lastModEndDate=2021-10-22T13:36:00.000%2B01:0

When getting the current date in Smartsheet bridge, it doesn't automatically encode the + sign to %2B in the {{data reference}} of the endpoint.

Any Suggestions?

Find more posts tagged with

Bridge

Accepted answers

SteyJ

Hey all,

If you run into this post — you can fix the issue with a single line of javascript.

return inputString.replace(/+/g, "%2B")

where the parameters are inputString with the appropriate value:

All comments

SteyJ

Hey all,

If you run into this post — you can fix the issue with a single line of javascript.

return inputString.replace(/+/g, "%2B")

where the parameters are inputString with the appropriate value:

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.