Making a REST call with values containing an apostrophe

Currently, I am utilizing REST and ajax to retrieve data from SharePoint using the URL below:

https:xxxxxxxx/_vti_bin/ListData.svc/RMSD_Tasks?$orderby=IssueValue asc,StatusValue desc&$filter="+dropValue+" eq '"+secondFilterVal+"'&groupby=IssueValue/StatusValue

Most of the time, everything functions perfectly fine. However, there is an issue that arises occasionally. At times, the value of secondFilterVal contains "Manager's Bulletins" with an apostrophe. Whenever this value is present, I receive a bad request message upon making the call. Is there a solution for this problem? Unfortunately, changing the text "Manager's Bulletins" is not an option. One thought I had was to use "$filter=substringof.....", but it has been working seamlessly with other cases. Any suggestions on how to handle this situation would be greatly appreciated. Thank you!

javascriptajaxrestsharepoint-2013

Answer №1

Big shoutout to @Lauri and @charlietfl for their insightful input. The advice from @charlietfl really helped broaden my perspective, leading me to discover the usefulness of encodeURIComponent(). After consulting MDN's encodeURIComponent() and the informative resource on REST Filters, I was able to resolve my issue by implementing the code snippet below:

Interestingly, you have to use the apostrophe twice: The output Manager%27%27s%20Bulletins functions flawlessly.

var str = fixedEncodeURIComponent("Manager's Bulletins");

function fixedEncodeURIComponent(src) {
    return encodeURIComponent(src).replace(/[!'()*]/g, function (c) {
        return '%' + c.charCodeAt(0).toString(16) + '%' + c.charCodeAt(0).toString(16);
    });
}

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Unable to click, but can only be activated by touchstart or mousedown

Is it possible to bind a 'click' event to a paragraph? Here is the function I am using: $(document).on('touchstart mousedown',"p span.text", function(e) { console.log('I was clicked'); *more code here* }); When I ...

javascriptjqueryjquery-events

MapBox notifies when all map tiles have finished loading

Currently, I am utilizing the Mapbox GL JS API to manipulate a Mapbox map. Prior to sending my result (which is a canvas.toDataURL) to the server via HTTP, I must resize my map to a larger resolution and then use fitbounds to return to the original points. ...

javascriptjqueryangularjsmapboxmapbox-gl-js

A guide to importing a Vue component in a JavaScript file

I am looking to achieve a specific behavior in my project: depending on a condition stored in my database, I want to load a particular vue.component instead of another. For example, within a file named discover.js, there is the following code: Vue.compone ...

javascriptlaravelvue.jscomponents

Retrieving information from a previous AJAX request using AJAX

I am facing an issue with my page where data is dynamically loaded using AJAX calls. Main Page: $( document ).ready(function() { $( "#searchbar" ).load( "searchbar.php" ); }); $( document ).ajaxStart(function() { $( "#loader" ).show(); }); $( documen ...

phpjqueryajax

What is the method to dynamically modify the value of location.href using vanilla javascript?

I have a button that looks like this: <button type="button" class="play-now-button" onclick="location.href='www.yahoo.com'">Play Now</button> However, I want to change the location.href value using vanilla JavaScript. The code below ...

javascripthtmldebugging

`Javascript often returns NaN for basic calculations`

Hello, I am currently developing a basic calculator for a game but I have encountered an issue. Despite having just started learning this programming language and reading all available tutorials, I am now in the process of writing code to gain more experie ...

javascript

Mysterious failure of JavaScript regular expression when encountering the term "tennis"

We developed a JavaScript script to detect duplicates or potential duplicates, but it seems to have some issues with certain words like "tennis." The script functions correctly in most cases, but fails when analyzing phrases related to the word "tennis" fo ...

javascriptjqueryhtmlregex

Altering the names of fields in a REST API's response

Greetings! As a newcomer, I might not grasp advanced solutions right away. Let's get to the point: I need to send a response for a REST API. Essentially, what's happening is that I return an object from a method and then the fields of those obje ...

javajsonspringrestspring-mvc

What is the significance of `(<typeof className>this.constructor)` in TypeScript?

After inspecting the source code of jQTree, written in Typescript, available at https://github.com/mbraak/jqTree, I came across the following snippet: export default class SimpleWidget{ protected static defaults = {}; ...

javascripttypescript

The importance of managing both synchronous and asynchronous processes in Javascript

As I delved into the intricacies of Javascript's asynchronous behavior within its single-threaded environment, I stumbled upon a comment that caught my attention regarding the following code snippet: request(..., function (error, response, body) ...

javascriptasynchronousprocess

Troubleshooting problems with AJAX JSON API responses and dealing with undefined variables and issues related to [

I am currently working on a new API project and I'm facing some challenges. I have removed certain information, like the Bearer token, for privacy reasons. This is my first attempt at creating an API and I could use some guidance. Reading books and br ...

jqueryjsonajax

Restrict the quantity of user responses with JavaScript

For this questionnaire, users are limited to selecting and ranking only 3 out of the 5 listed Social Apps. I am currently using questback to build the survey, but I require assistance in implementing a JavaScript condition. <table> <tr> & ...

javascript

The route parameters seem to be malfunctioning when using the Google Maps Directions API

Currently, I am attempting to transfer the latitude and longitude of a location from one HTML file to another using the $routeParams feature. In the second HTML file, I utilized the Google Maps directions API to display the directions from the source lati ...

javascriptangularjsangularjs-routinggoogle-directions-api

Execute an AJAX request in JavaScript without using string concatenation

On my webpage, users input code in a programming language which can be over 2000 characters long and include any characters. When they press the send button, the code is sent to a server-side script file using JavaScript AJAX. Currently, I am using the fo ...

javascriptjqueryajax

I am trying to figure out how to properly utilize server-only functions within Next.js middleware

In my current project, I am utilizing Next.js 13 along with the App Router feature. While attempting to include a server-specific fetch function in middleware.js, an error message is encountered: Error: Unable to import this module from a Client Compone ...

javascriptnext.jsmiddleware

Challenging Trigonometry Puzzles in Javascript

In my project, I am creating an interactive application where a group of humans and bacteria engage in a game of chase. However, I encountered a problem where instead of moving directly towards their target, all entities would veer to the left. I attempt ...

javascripthtmltrigonometry

Divergence between two distinctive occurrences in Google Analytics

Why are there differences in the number of unique events recorded by Google Analytics for two consecutive events? I have set up onClick tracking for a button. When the button is clicked, an event (Event 1) is sent to Google Analytics and a CSS-selector ap ...

javascriptcookiesgoogle-analyticsgoogle-tag-managertracking

Tips for creating dynamic row styles in a fluid table layout?

Could someone help me figure this out? I'm not familiar with JavaScript and need assistance as I've never created it, only edited existing scripts. I have a layout with two tables side-by-side. On mobile devices, the second table is pushed below ...

javascripthtmlcssresponsive-design

What is the best way to modify a particular value buried within a JavaScript object?

Within my node project, I am working with a JavaScript object like the one shown below: that.responseData = { fields: { id: { label: 'ID', value: objectRecord.id, info: '', ex ...

javascriptnode.jsobjectecmascript-6

Retrieval of components from JSON array of objects

I have a JSON array containing objects stored on the server. How can I access the first object to print its contents? The data is in the following format: [ { "eventId": "8577", "datasetId": "34", "nodeId": "8076", "typeId": "4", "type": ...

javascriptarraysjson