Data Upload Tool | Zoho Creator Help

Data Upload Tool

The Data Upload Tool is a simple data upload tool that allows you to upload your existing CSV file to Zoho Creator so that you can insert or upsert records.

To be able to perform this, you need to create Self Client here:

Note: Installing Java is a prerequisite for using Java Upload tool. Click here to download.
  1. Navigate to the API Console and Get Started.
  2. Select Self Client option.
  3. Click Create button.
  4. Click OK. Self client is created.
  5. Download and extract the zip file provided here. This is the Java Upload Tool.
  6. Navigate to the Directory ZohoCreator/UploadTool/bin folder.
  7. Execute the File run.sh (for Mac and Linux) or run.bat (for Windows) based on the operating system.
  8. Execute sh run.sh filePath -e appLinkName -a formLinkName (for insert).
  9. Execute sh run.sh filePath -e appLinkName -au formLinkName fieldLinkName (for upsert).​

    The following are the arguments as represented in the above image:

    • Argument 1: CSV Filepath
    • Argument 2: -e (Existing App Operation)
    • Argument 3: Application Link Name
    • Argument 4: -a (or) -au (add or upsert)
    • Argument 5: Form Link Name
    • Argument 6: Field Link Name (need only if the operation is upsert)
  10. Choose your DC.
  11. Enter owner name.
  12. Enter Client ID. Copy this information from the Client Secret tab that you saw while you created self client.
  13. Enter Client Secret. Copy this information from the Client Secret tab. You will be required to enter Authentication Code.
  14. Navigate to Self Client. Go to Generate Code tab.
  15. Enter Scope: ZohoCreator.meta.form.READ, ZohoCreator.data.CREATE.
  16. Click Create. Code is generated.
  17. Copy code and paste in terminal.
    Authentication will be completed.
  18. The records are then added or updated, accordingly.

Note: Authentication is a one-time procedure. Once you create the credentials, the Access Token will get generated automatically for consecutive API calls.

Clear Account Details

To clear your account details associated with the tool, you have to run the following command:

  • sh run.sh -clear

This removes the existing connection. Following this, you need to provide the Client Details of the new account in Self Client and repeat the procedure to authenticate the account.


    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Capture data using NFC

                                                                                                                Requirement Capture data from NFC supported tags. Use Case An organization wants a mechanism where its employees can submit feedback about its cafeteria and restrooms by tapping their NFC- enabled ID cards against the feedback collecting ...
                                                                                                              • Periodically upload files in Zoho Creator to Zoho Workdrive

                                                                                                                Requirement Perform integration between Zoho Creator and Zoho Workdrive, and use Schedules to upload files from Creator to Workdrive on a monthly basis. Use Case   A project tracker app maintains report files of finished projects in a form - ...
                                                                                                              • Understand file upload field

                                                                                                                The File Upload field enables your users to upload a file while submitting their data through your form. Your users can select the file either from their device (in the device's local storage) or from any of cloud storage services we support. The ...
                                                                                                              • Upload media

                                                                                                                This API service lets you manage the different functionalities in a form. Upload media Methods upload(media:withFileName:for:form:completionHandler:)This uploads files entered in the file upload, audio, video, and image fields in the form. This has ...
                                                                                                              • Set browse options for file upload field

                                                                                                                Set browse options for file upload field Refer to this page to learn about the File upload field Open the form builder. Select the required file upload field. Navigate to the Field Properties > Browse Options section on the right. Check the required ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources