api_authenticate returns error 20, Unknown username/password

Question

I am trying to do the api_authenticate in order to do the api_importfromCSV and am failing. It seems pretty simple, but it is failing.

Here is the link
$urlQuery=" https://fixandpaint.quickbase.com/db//main?a=API_Authenticate&appToken=xxx_valid_token&usern..."

$data=Invoke-RestMethod -Uri $urlQuery

But even running the link manually gives the error.

Any help would be greatly appreciated.

Thanks,
Dean

deanousterhout · Answer

Would an "=" sign in the password field cause issues?

deanousterhout · Answer

Mystery solved... sort of... the = was causing the problem. &nbsp;Is there a way to escape special characters like the = in a password?

_anomdiebolt_ · Answer

Use&nbsp;%3D for =.I don't know what language you are using but every modern language has a URLEncoding function. If you URL is coming from the QuickBase formula language you use this:URLEncode([url])

deanousterhout · Answer

Thanks Dan. &nbsp;I am using powershell... I will lookup the urlencode.

_anomdiebolt_ · Answer

$Encode&nbsp;=&nbsp;[System.Web.HttpUtility]::UrlEncode($URL)&nbsp;$Decode&nbsp;=&nbsp;[System.Web.HttpUtility]::UrlDecode($Encode)&nbsp;Do us a favor and post your script when it is debugged.

Forum Discussion

api_authenticate returns error 20, Unknown username/password

Related Content

Authentication using username/email and password

Formula-Numeric Field Returning Null Instead of 0

Pipeline Make Request - Return Make Request JSON Output into fields

Make Request JSON returning blank when only one record returned

Color-coding a field returns field name