Zoho Projects API v3 - How to format filter critera in deluge

Zoho Projects API v3 - How to format filter critera in deluge

I'm trying to return the id of a client company in the Zoho Projects API using Zoho Flow and am running into issues about how I format critera in deluge.

https://projects.zoho.com/api-docs#clients#get-clients

I have several hundred Client Companies, and the example response for one of them looks like this :

  1. "clients": [
  2.       {
  3.             "zipcode": "",
  4.             "address_second": "",
  5.             "country": "",
  6.             "city": "",
  7.             "zohocrm_account_id": "272658000004270001",
  8.             "address_first": "",
  9.             "name": "Acme",
  10.             "id": "91102000007078211",
  11.             "state": "",
  12.             "webaddress": ""
  13.         },


I am using this Deluge

  1. string ZP_FetchClientCompany()
    {
        // Replace client company id with variables. This is just for testing
        varClientName = "Acme";
        varCRMID = 272658000025608001;

        // Create a filter parameter (ensure correct JSON format)
        filterParam = {
            "criteria": [
                {
                    "field_name": "name",
                    "criteria_condition": "contains",
                    "value": varClientName
                }
            ],
            "pattern": "1"
        };

        // Convert to proper JSON format
        filterJSON = filterParam.toJSONList();

        // Create parameter map with the correct JSON format
        paramMap = Map();
        paramMap.put("filter", filterJSON);

        // Send the request
        updateResponse = invokeurl
        [
            url :"https://projectsapi.zoho.eu/api/v3/portal/MYPORTAL/clients"
            type :GET
            parameters:paramMap
            connection:"MY_CONNECTION"
        ];

        info updateResponse;
        return updateResponse;
    }

When I run this code I get the error :

{
   error : {
      status_code : "400",
      instance : "/api/v3/portal/20070208318/clients",
      title : "JSON_PARSE_ERROR",
      error_type : "FIELDS_VALIDATION_ERROR",
      details : [
         {
            message : "Invalid JSON syntax",
            field_name : "filter"
         }
      ]
   }
}

I have tried so many ways of formatting the filter and I can't get it to work : I just want to find the record that matches the Company Name











    • Sticky Posts

    • Tip: How to print the Gantt View

      Though we move from the traditional project management system (using papers) to an online project management system, we still prefer to have a printed copy of the activities/tasks that are to be done in the project. This way, we can carry the to-do lists with us for the meetings and refer when we are offline. The print option, available at the right side of the page, allows the users to print the project information across all the modules. However, this option failed to print all the tasks & milestones
    • Project Management via Emails in Zoho Projects

      We write mails to communicate. In Zoho Projects, we can write mails to collaborate. Yes, Zoho Projects supports Email based project management. The mails that you send turn into tasks, bugs, project comments, forum replies, etc. The following are some of the frequently asked questions that might be of some help to you. What are the pre-requisites to manage my projects through Emails? You need to have a personal / business mail ID that is registered and confirmed with accounts.zoho.com To learn more
    • Four types of task dependencies

      "Nothing is particularly hard if you divide it into small jobs."                                                                                                                  - Henry Ford Projects, small or large, are driven by simple work units called tasks. Monitoring standalone tasks might look simple but as the workflow becomes elaborate, tasks may start relying on one another. In project management, this relationship between tasks is termed as "Task Dependencies". Dependency between tasks arise
    • Task and Project numbering

      Zoho Projects now generates a unique number for each project, task, and issue added. The auto-generated ID is a combination of a prefix and a number which is assigned by Zoho Projects. The unique IDs for projects, tasks, and issues will be useful to track, identify, and search easily. You can modify the settings to enable or disable the Project and Task IDs.  Learn more on how to modify Prefix & ID settings for projects and tasks. Issue IDs cannot be disabled, only its prefix can be changed (tasks
    • Task Inline Editing Enhancement

      Hi All, Today, we have made an enhancement in task inline editing. In 4.0, task edit is moved in a single screen in a pop-up. We designed this in-order to make the task edit across the product to be the same. Let it be in Feeds, Tasks & My Tasks tab, Calendar & My Calendar tab, a click on the task title will open the popup and user can edit the values. Customers pointed us the inline editing was very useful to them & how much they miss that in 4.0. Based on the feedback, we have rolled out this enhancement.
    • Recent Topics

    • Automate Zoho Meeting Creation via Blueprint (Leads & Accounts)

      I need help automating Zoho Meeting creation during a blueprint transition in both the Leads and Accounts modules. Requirements: Triggered via blueprint Read meeting start time (DateTime field) and internal participants from CRM Create Zoho Meeting via
    • Forecast UI improvements

      Hi I have two improvement requests for the UI in the Forecast function. Can you add the ability to reorganise the Pipeline, Committed and Best Case columns on the Forecast? I thought they were in alphabetical order, so we renamed them so that we could
    • Cómo guardar datos de subformularios en filas individuales en Zoho Sheet o Google Sheets

      Hola comunidad, Estoy trabajando con un formulario principal en Zoho CRM llamado Clientes, el cual incluye un subformulario llamado Productos (máximo 3 productos por cliente). En el formulario principal tengo los siguientes campos: Cliente Teléfono Correo
    • ZOHO BOOKS EXPERT

      We are planning to migrate from Quick Books to Zoho Books, and are looking for a professional with experience in migration to Zoho Books and the setup of Zoho Books. Currently, we have two companies and two Quick Books accounts, and we want to integrate
    • Currency fields and decimal places in CRM email templates

      Hi, How do I get more than the standard 2 decimal places showing in a Currency field, on an email template? In the Layout for my Currency field, it is set to 6 decimal places. I want to show up to 6 places in the email template (unrounded). See attached
    • Pin multiple columns and adjust column widths in CRM subforms

      Hello all, Subforms act as secondary forms or tables in which you can associate multiple line items to a primary record and thereby ensure more structured and comprehensive data organization. We've made some recent enhancements to subforms. Here's what's
    • Can you please let us know how we can use Zoho for multi store?

      Hello Team, Can you please let us know how we can use Zoho for multi store because when we connect our plugin to Zoho and we create a product and then on another store when we create product with same name then product already exist error occurs, so how
    • Estimating Project Costs in Zoho Projects – Based on Hours and External Costs

      Hi everyone, I'm currently setting up a project in Zoho Projects and working on implementing a budgeting structure. I’ve already enabled cost tracking based on hours logged to tasks, but I’m looking to expand this to estimate total actual costs, based
    • Assistance Required for Zoho Bulk Import Error

      Hi, I am currently attempting a bulk import in Zoho with a small batch of records to test if the import will be successful. However, despite matching all fields correctly, I continue to encounter the following error: "Not a standard user: Prospect Owner."
    • Invoice status on write-off is "Paid" - how do I change this to "Written off"

      HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a way
    • Sending possible. Receiving not possible.

      We are not receiving mail in our company email. Could you please solve this. It has been recurring and I want it to be resolved once and for all. Please help.
    • Introducing ICR in Zoho CRM: Transform your printed text into digital data

      From writing on papyrus in the ancient times to creating a humble record in your CRM, the world may have evolved with how it used to record data, but data entry as such has not been simplified. It is still a repetitive and arduous chore on which businesses
    • Print a price list or price book

      Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more
    • Introducing Assemblies and Kits in Zoho Inventory

      Hello customers, We’re excited to share a major revamp to Zoho Inventory that brings both clarity and flexibility to your inventory management experience! Presenting Assemblies and Kits We’re thrilled to introduce Assemblies and Kits, which replaces the
    • Marketing Automation Emails Going to Spam

      Google is trapping all the marketing automation emails in spam. My domain has a perfect reputation and it looks like Zoho has a low reputation which is sending it to spam. When I pull the email out of spam and click on a link in the email, I get this
    • Page Break

      Is there a way to set page breaks in Zoho Sheet. I couldn't find anything about it on the board.
    • Zoho Projects API - Searching Projects by Custom Field

      Hi How can I search all projects by a custom field? I can confirm that using the search_term parameter as documented here does not work for me: https://www.zoho.com/projects/help/rest-api/search-api.html#alink3 My search term is "22424", which corresponds
    • Can we have Backorder Management ?

      Can we have Backorder Management ?
    • How to see history on Bulk send of Customer Statements

      Hi, We bulk send statements to customers every month via Books - every month we have customers emailing requesting a statement. Currently I have no visibility on if a customer was sent the statement or not and if our process is being followed or overlooked
    • A few Issues when using "Pay Bill via Check"

      We have quite a bit of issues with how paying for Bills via Check works. Would love some feedback from the Zoho team in case we are doing something incorrectly. 1. When we go from a vendor and select "Pay Bill via Check" option, we see ALL the outstanding
    • Presenting the brand new Zoho Bookings!

      Hello everyone, Greetings from Zoho Bookings! We're happy to announce a new version of our product with enhanced features to simplify scheduling, coupled with a sleek interface and improved privacy across teams. Here's what you can expect from the latest
    • zoho crm intergration with zoho campaign

      I  to intergrate zoho CRM with zoho campaigns https://help.zoho.com/portal/en/kb/crm/integrations/zoho/zoho-campaigns/articles/zoho-campaigns-crm-integration#Configuring_the_integration_and_setting_up_sync but in step1, when i click to zoho campaigns,
    • Zoho desk not sending call reference to user

      Hi, I am using zohone desk and have setup the call logging email address but sadly users are not getting a call reference notifying them that the call has been logged also can't see the updated call when it is going through faces. My question is, is there
    • Bank transaction automation

      I would like to automatically update the "Reference#" field with whatever text is in the "Description" field each time Zoho Books pulls my bank feeds. I've figured out the automation all the way up to the Field Update, where "Reference Number = ...???"
    • Why Format section gets disabled when we create Merge Template over PDF

      I need some assistance I have a Client who is going to give certificates to users who passes his exam. So, I am using mail merge but in ZOHO writer after I upload the PDF and create merge Template over PDF the format Section gets disabled. My problem
    • Problem connecting social accounts and file upload

      I have two brands that I manage in Zoho, each with their own social profiles. I didn't have any issues for the first few months, but recently the Instagram for one got disconnected and no matter what I've tried, it won't reconnect. If I go into the settings
    • How to add a pre-filled form to a mobile app

      We are building a mobile app that API's lead info from ZOHO crm (leads module) and would like to add a refer a friend program via a ZOHO form the would prefill their info (Name, Email and Phone) whilst they add the person they are referring (Name, Email,
    • Is there a way to set up templates for commonly occurring issues on Zoho Desk

      Hi there, We have recently migrated our service desk over to Zoho. I was wondering if there is a way we can set up custom templates for specific requests that we commonly get from our customers. Example: Customer often requests a password reset. There
    • Sheet View for Reports

      Hi - is there any plan to make a "Sheet View" function for reports??? It would be a huge improvement.
    • instagram direct message

      is it possible to check and reply Instagram direct messages?
    • Automation #6 - Prevent Re-opening of Closed Tickets

      This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Typically when a customer submits
    • Zoho Payroll's USA and KSA editions are available in Zoho One!

      Greetings! We’re excited to share that Zoho Payroll, currently available only in India and the UAE, is now introducing the KSA (Kingdom of Saudi Arabia) edition and the USA (United States of America) edition, and these editions are now available in Zoho
    • What is the difference between a template and a snippiet

      Hi there, I am currently working on optimising our service desk and improving the consistency of our responses. I have come across two tools that appear to help do this, templates and snippets. I was wondering what the similarities and differences are
    • Zoho Recruit - Automatic email before expiry date

      Hi, how can we automate email going out to candidate if one of the 3 fields are 30 days or less before expiry? All available workflow triggers are update/create/delete based but I want this to be independent of any activity on candidates profile. Is it
    • Display CRM account field on Zoho Desk Ticket

      I have linked a custom CRM Account field for "Customer Care Lead Advisor" with Zoho Desk Accounts. I know the data has synced correctly as I am using this field for some automations based on this lead advisor field. When viewing a ticket that is linked
    • Announcing Early Access to "Zoho CRM for Everyone" — A new and exciting update to Zoho CRM

      We are delighted to announce an Early Access to Zoho CRM for Everyone— a truly democratic approach to managing a CRM, gift-wrapped in an exciting and intuitive user interface. Here, multiple teams across an organization can coordinate among each other
    • Function #35: Close all tasks associated with a lead and create a new task.

      Welcome back everyone! Last week, we learnt how to close all tasks of a deal depending upon the deal stage. This week, let's look at a custom function that lets you close all of the tasks associated with a lead while simultaneously creating a new task, like when you need to halt all progress towards a lead while the lead is not available at the moment but create a reminder task. Business scenario: The success of a company, in one way or another, is determined by the leads it gets. Each lead is just
    • Tables for Europe Datacenter customers?

      It's been over a year now for the launch of Zoho Tables - and still not available für EU DC customers. When will it be available?
    • Exchange Rate Updates

      Hi, It would be great that when you work with multiple currencies, the exchange rate updates automagically every day (as seen on Zoho Books) or at least that when you create/update an opportunity the exchange rate could be manually updated, or maybe both!
    • Feature Request - Approval Processes

      Hi Team, I think it would be really valuable to add the approval process feature like what is currently available in the CRM. The problem with the current approval support is it can't be automated to send the approval to set people based on the values of fields within the tickets. Is this something that could be considered for the roadmap? Thanks, Harry
    • Next Page