Google Apps Script, OAuth2, and Salesforce

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP

Google Apps Script, OAuth2, and Salesforce



I am trying to get this demo working: Google Apps Script / Salesforce.com



I have watched the linked video several times, searched and search for hours for a solution, but I continue to get the same error as others:




error=redirect_uri_mismatch&error_description=redirect_uri%20must%20match%20configuration



Questions:
1) Do we still need to change the callback url from "script" to "docs" when the using a script bound to a spreadsheet? I have tried it both ways.



2)Do I need to change endpoint urls because of my salesforce having a custom domain in the form of mycompany.cloudforce.com ?



Thank you in advance for your help.





Can you show me your redirect URI? It looks something like 'localhost:8080/oauth2callback'; (when testing locally) in your Google Dev Console.
– noogui
yesterday





That code and video are a bit old, not sure if everything still works there. You might want to try this sample instead: github.com/gsuitedevs/apps-script-oauth2/blob/master/samples/…
– Eric Koleda
16 hours ago





So I opened the Developer Tools in Chrome, went to the Console tab, ran the code, got the error message mentioned previously, and what I got was "Failed to load resource: the server responded with a status of 400 (Bad Request)" along with a link: login.salesforce.com/services/oauth2/… (replaced my info with XXX)
– Jason Phillips
13 hours ago






Eric, I also tried that code, and received the same exact error.
– Jason Phillips
12 hours ago





the gsuitedevs code gives me this URL login.salesforce.com/services/oauth2/…
– Jason Phillips
12 hours ago




1 Answer
1



Success! I was able to successfully get past this hurdle...got to the login page.



the function




logRedirectUri()



in the gsuitedevs code gsave me the correct callback URI






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Comments

Post a Comment

Popular posts from this blog

Executable numpy error

Image
Clash Royale CLAN TAG #URR8PPP Executable numpy error I'm trying to create an executable file for my code. I've already tried with cx_Freeze and with pyinstaller. Both gives me the same error, which is: "Missing required dependencies 0.format(missing_dependencies))" PS C:UsersGustavoDesktopbuildexe.win32-3.6> python AgendaOficial.py C:UsersGustavoAppDataLocalProgramsPythonPython36-32python.exe: can't open file 'AgendaOficial.py': [Errno 2] No such file or directory PS C:UsersGustavoDesktopbuildexe.win32-3.6> .AgendaOficial.exe Traceback (most recent call last): File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_Freezeinitscripts__startup__.py", line 14, in run module.run() File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_FreezeinitscriptsConsole.py", line 26, in run exec(code, m. dict ) File "AgendaOficial.py", line 8, in File "C:UsersGustavoAppDataLocal
Read more

PySpark count values by condition

Image
Clash Royale CLAN TAG #URR8PPP PySpark count values by condition I have a DataFrame, a snippet here: [['u1', 1], ['u2', 0]] basically one string ('f') and either a 1 or a 0 for second element ('is_fav'). What I need to do is grouping on the first field and counting the occurrences of 1s and 0s. I was hoping to do something like num_fav = count((col("is_fav") == 1)).alias("num_fav") num_nonfav = count((col("is_fav") == 0)).alias("num_nonfav") df.groupBy("f").agg(num_fav, num_nonfav) It does not work properly, I get in both cases the same result which amounts to the count for the items in the group, so the filter (whether it is a 1 or a 0) seems to be ignored. Does this depend on how count works? count 1 Answer 1 There is no filter here. Both col("is_fav") == 1 and col("is_fav") == 0) are just boolean expressions and count doesn't really care about their value as long a
Read more

Trying to Print Gridster Items to PDF without overlapping contents

Image
Clash Royale CLAN TAG #URR8PPP Trying to Print Gridster Items to PDF without overlapping contents I want to print gridster items to pdf using chome browser. Unfortunately the item overlaps on next page. Is there any way to make gridster item go to next page if it doesnt fit in the current page when printing to pdf? Screenshot By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Read more