Document is weak

Hi.

I want to work only sheet api

my problem;

I can't get TOKEN...

Step 1:

req

1. https://accounts.zoho.com/oauth/v2/auth
   
2. ?response_type=code 
   
3. &client_id=1000.P4Z0WWOLFDGRT23126TYD3B4JWQ5TE
   
4. &scope=ZohoSheet.dataAPI.UPDATE,ZohoSheet.dataAPI.READ
   
5. &redirect_uri=http://mydomain.com/zoho_result.php
   
6. &state=-5466400890088961855
   

res

1. http://mydomain.com/zoho_return.php?state=-5466400890088961855&code=1000.041b7b5928bbab9f0af9fdce95126e73.1fac756c41995bd37728b2ec5c1f2d1d&location=us&accounts-server=https%3A%2F%2Faccounts.zoho.com&
   

Super... I get my CODE...

Step 2:

req

1. https://accounts.zoho.com/oauth/v2/token
   
2. ?code=1000.041b7b5928bbab9f0af9fdce95126e73.1fac756c41995bd37728b2ec5c1f2d1d
   
3. &grant_type=authorization_code
   
4. &client_id=1000.P4Z0WWOLFDGRT23126TYD3B4JWQ5TE
   
5. &client_secret=83r359de68c312ta5f1f06c3b1319ab98f59fa246d
   
6. &redirect_uri=http://mydomain.com/zoho_result.php
   
7. &scope=ZohoSheet.dataAPI.UPDATE,ZohoSheet.dataAPI.READ
   

res

1. 400 Bad Request
   
2. code: 1000.041b7b5928bbab9f0af9fdce95126e73.1fac756c41995bd37728b2ec5c1f2d1d
   
3. grant_type: authorization_code
   
4. client_id: 1000.P4Z0WWOLFDGRT23126TYD3B4JWQ5TE
   
5. client_secret: 83r359de68c312ta5f1f06c3b1319ab98f59fa246d
   
6. redirect_uri: http://mydomain.com/zoho_return.php
   
7. scope: ZohoSheet.dataAPI.UPDATE,ZohoSheet.dataAPI.READ
   

I can't my Access Token. I used Online Api Explorer (generate access token)

• Topic Participants

• akinkoker

• Jaya Shankari S

• Sticky Posts

• Revamped Print in Zoho Sheet—customized for paper

  The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.

• Slicers are now available in Zoho Sheet—filter your data interactively

  At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

• Check out the new Checkbox in Zoho Sheet

  Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format

• Format and analyze spreadsheet data with Zoho Sheet's Table

  While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,

• Introducing Data Bars: Graphically represent changes in data within the cells

  Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method

• Recent Topics

• Setting up CRM for RFP workflow management

  This will be the first time our organization uses an off-the-shelf CRM, transitioning from our homegrown custom solution, and I would appreciate general thoughts on how to get started in general with our workflow using Zoho CRM. The main question: if

• Integrating Calendly with Zoho Calendar in Zoho Mail

  I moved my office into a business incubator space that uses Calendly for meeting management and events. Calendly doesn't have a integration with Zoho Calendar and vice versa. I was directed to Zapier for integration but it doesn't have an integration

• How to send binary data in invokeurl task?

  Hello, I am using Adobe's Protect PDF API. Source: https://developer.adobe.com/document-services/docs/overview/pdf-services-api/ Everything works fine in Postman. But for some reason after encrypting the file, it is empty after password protecting the

• Unable to access Zoho Desk at all - has an extreme slow load and then just remains blank

  This is all I see:

• Demande : Épingler automatiquement un commentaire via Deluge

  Bonjour, Je suis utilisateur de Zoho Desk et j'ai développé une fonction avec Zoho Deluge permettant d'ajouter automatiquement un type de commentaire à chaque création de ticket. Cependant, j'aimerais pouvoir épingler ces commentaires directement depuis

• Unknown error occurred

  Hi, When we want to publish or edit a page in our website, we encounter with "Unknown error occurred" problem. I share a screenshot here. Our website is www.essoft.com. It happens every page. We want to solve this ASAP.

• Using Creator API access tokens in deluge script

  I am working on generating download urls for files that are uploaded via a creator form. I want to include these urls in record templates so they can be easily accessed. The goal is to make downloading multiple attachments in a record as quick and easy

• Option to Re-order from past orders

  Customers would like to place a repeat order with the business entity. Currently there is no option to support this and everytime the customer has to check out following the same process. Can a option be given to reorder from the past orders?

• Display your zoho contact name when they call your mobile number

  As per the title If a contact calls the office number, the contacts name shows on mobile as long as I have their contact details registered in my crm. Is there a way that if the contact calls my mobile, their name can be displayed? Currently just their number shows when they call.

• US to EU Data Migration done / Workflows and Custom Functions stopped working

  Hello, I need help to restore my workflow rules and custom functions to work. My data was transferred from the US to the EU (Data center migration). Now all Workflow Rules and Custom Functions not working. I have no idea how to restore them to work again.

• Custom view for Milestones

  Hi, Just an idea for the future... would it be possible to create custom views for the Milestones view under Work Overview ? I usually need to look at this view filtered by project group but the filter doesn't remain when navigating away. A custom view

• Zoho API Error Code 7019 when adding job.

  Hello, I am following the documentation found here. https://www.zoho.com/people/api/timesheet/adding-jobs.html Regardless of how I try and post the data (including just using the example requests), I receive back the response {'response': {'message':

• Getting error during inserting a record in form of zoho people using zoho api

  import requests import json # Set your access token and Zoho People API base URL access_token = '1000.XXXXXXXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXX' api_base_url = 'https://people.zoho.in/people/api/' # Set the form name and data to be inserted form_link_name

• Email an Invoice from API

  When calling the API to email an invoice, it seems it does not actually send it. Below is a screen shot where I used an API call for the bottom record, and it updated its' status to "Due Today", but no email was actually sent. The top record, I hit the

• How to delete Email Sent From CRM from Contact Records

  I can't figure out how to delete email sent form CRM from contact records. Can you please advise? 

• Recurring Events Not Appearing in "My Events" and therefore not syncing with Google Apps

  We use the Google Sync functionality for our events, and it appears to have been working fine except: I've created a set of recurring events that I noticed were missing from my Google Apps calendar. Upon further research, it appears this is occurring

• Is there a Kanban view of Tasks across all Projects?

  As the title indicates, I could use a Kanban view of my Tasks across my Projects. If it's there, I don't see it. If it isn't there, I'd like to submit this as a feature request. Thx.

• CRM Deluge how can link attach file with workdrive file.

  Hi, We have create file at workdrive and would like to link to attachment at crm module by deluge. Right now can only upload it to attachment but can not link the file from workdrive. Thank you

• Tropicalize Books

  Books is an incredibly powerful tool that works well in many countries. But I feel that it is a product that is not yet "tropicalized" for Brazil as we speak (this would be like adapting the local reality). We have many strong competitors who do more

• Refund of a check distribution fee...

  I use cashiers checks, from my local credit union, to pay some bills very occasionally. They charge me a 5.00 fee for this service, but then refund me that same amount at the end of the month on my statement. How would I record this transaction in Zoho

• Usuários do Zoho Recruit no Brasil

  Gostaríamos de interagir com outros usuários do Zoho Recruit. Acabamos de completar um ano de utilização. Quem mais usa? se usa outra qual é?

• Zoho Creator Upcoming Updates - December 2024

  Hi all, We're excited to be back with the latest updates and developments on the Creator platform. Here's what we're going over this month: Deluge AI assistance Rapid error messages in Deluge editor QR code & barcode generator Expandable RTF and multi

• Questions about To Do

  1. I created a To Do note on Android and there is a line sorting option in the options drop down menu. But I didn’t find such an option in the PC client. I really need this option. 2. Why is there no search in To Do on the PC client? 3. Why is there no

• Introducing Offer Details Sync to Zoho People

  We've introduced a new option for the Zoho People integration that allows you to push offer details when a candidate is converted to an employee. This simplifies your recruitment-to-onboarding process by seamlessly syncing critical offer information,

• Conversion of functions from Google Spreadsheets

  Hello! I use this formula "=QUERY(ResumoOrdemVencimento!A3:O38;"SELECT A,B,C,D,E,F,G,H,I,J,K,L,M,N,O WHERE C != '' ORDER BY C,G")" in Google Sheets but when importing my spreadsheet into Zoho Sheets the formula was not converted. The QUERY function brings data from another spreadsheet, and then I sort and apply conditional formatting. The order of data will change automatically as I update the source spreadsheet. What Zoho Sheets function is equivalent to QUERY? I have some other spreadsheets to

• Copy, Duplicate, or Clone a Custom View?

  I searched the forums and didn't see anything on the subject. Is there a way to copy, duplicate or clone a custom view? I want a custom view similar to one I've already created. I just want the columns in different order.

• Import from OneNote

  Is there a way to import notes from OneNote? 

• In Zoho Forms - adding a Zoho CRM field for Contact barely shows any fields.

  I'm making a Zoho Form and I want to add a CRM field for Contact. I was expecting to be able to match the contact on the email address provided in the form. My standard layout has lots of fields but for some reason on the dropdown list in Zoho Forms,

• Is Bigin Really Free - Confused by notifications?

  I started to look at Bigin as I was under the impression it was free, but as I started using it I kept getting messages that my trial period was X number of days and to upgrade. When I see something like this I assume I am not on a free version of anything

• What's New in Zoho Analytics - December 2024

  Hello Users! We’re excited to bring you a roundup of the latest features and improvements in Zoho Analytics. These updates are designed to elevate your data analytics experience, making it more powerful, interactive, and seamless. Let’s dive in! Expanded

• Tracking a loan from an investor - a new Bank or Credit Card

  I have an investor providing money from a HELOC (Home Equity Line Of Credit). I have also turned around and loaned this money to another company. But I want to track my outstanding balance of the debt that I owe to the HELOC. Would I / should I track

• Introducing Zia LLM: Zoho’s in-house Generative AI solution for CRM's AI capabilities

  Hello everyone, We're excited to announce the launch of our in-house Large Language Model (LLM) by Zia to power our AI offerings. What is LLM? LLM stands for Large Language Model, a powerful AI technology that processes and generates human-like text based

• The Zoho Meeting Video Quality Crisis

  I'm evaluating Zoho One for my business in Switzerland, and I must address a critical concern that threatens our potential adoption of the platform—the persistently poor performance of Zoho Meeting's video conferencing capabilities. In today's digital-first

• Pay run Error

  Trying to run the last payroll of the year. The payment doesn't get to the employee Due to Technical Glitch in Tool, kindly Help us and resolve IT's showing Technical Glitch from Bank Website But bank People saying contact Zoho team for further solu

• How to make the default currency type in a certain module different from the base currency>

  We have US dollar as the base currency. Also we have two more other currency types. In a custom module, we would like to make another currency as the default one rather than USD. Is it possible to do? How? Thank you very much!

• Track Contact's Employment/Account History

  Thank you in advance for all of your help! Is there a way, within Zoho, to keep track of a contact's employment history? For example, if John Doe is my contact at Account 1, but leaves the company and is hired by Account 2, can I... ...maintain John Doe

• CRM became very slow

  Plz check asap. image failed to upload , workflow doesn't run

• ZohoCRM Workflows Not Triggering After Tool Recovery

  I noticed that ZohoCRM experienced an issue earlier, and according to the status webpage (https://status.zoho.com/), all tools were reported to be fully restored as of 03:00 (PST) on December 30, 2024. However, ZohoCRM workflows are still not triggering

• API to post drafts for social media

  I we want to post draft posts to our zoho social account and then approve and schedule them within Zoho social. is this possible with for example: https://apis.zoho.com/social/v2/post TIA Jon

• What do the color presents represent on the parts of the website?

  I would like to customize my color palette, but I have no idea how each color relates to the parts of the website. It is labeled as uno, duo, trio, etc... Could somehow tell me how they're related or name them more intuitively? Thanks

• Next Page