• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Google Drive Search failed ( How to escape filenames for Google Drive API with apostrophe('))

Status
Not open for further replies.

salasia

Member
Hi, one of our workflows failed because it was searching for the following file on Google Drive:

1_They DON'T HAVE TO let us RACE! A MASSACRE_Pre-edit.mp4

Here's the "Data In" result:

{
"Api Endpoint Url": "https://www.googleapis.com/drive/v3...'application/vnd.google-apps.folder'&fields=*"
}

And here's the "Data Out" response:
{
"Error Errors 0 Domain": "global",
"Error Errors 0 Reason": "invalid",
"Error Errors 0 Message": "Invalid Value",
"Error Errors 0 LocationType": "parameter",
"Error Errors 0 Location": "q",
"Error Code": 400,
"Error Message": "Invalid Value"
}

Is it due to the apostrophe in "DON'T"?
Thanks in advance!
Sergio
 
P

Pabblymember11

Guest
Hey @salasia

Could you please share the name of the workflow in which you are facing such an error?
 
P

Pabblymember11

Guest
Hey @salasia

We have tested the same on the Postman application and Google Drive is not accepting the apostrophe on the text.

unnamed1.png


Though you can try searching the file by replacing the apostrophe with blank/nothing and can use "Substring" as a method.
 
P

Pabblymember11

Guest
Hey @salasia

You can refer to Google's API documentation perhaps they might have mentioned it. Else you can try reproducing the unaccepted characters.
 
Status
Not open for further replies.
Top