Fetch records from CRM connection for specific use, date range and status field

Fetch records from CRM connection for specific use, date range and status field

Hi folks,

I have got a deluge script (in a Zoho Cliq widget" that is pulling records from the Cases module in Zoho CRM. 

The script is working fine - BUT

I wan to limit the records being pulled to a very narrow condition as follows:

1. the logged in user is the Case Owner AND
2. the Case Status is not one of the following ("closed", "rejected") AND

The deluge current call to the CRM is as follows:

inquirylist = zoho.crm.getRecords("Cases",1,20,{"":""},"zohocrmauth");

Problem 1:

I am unclear how to structure the critera statement to reach the above, since there does not seem to be a way to do a nested called (eg. Status:equals:closed OR Status:equals:rejected).

It is possible for me to fetch all records and manually filter them, but the problem is that there may be 100's of records for an owner and paging through them may not give the latest open records.

Problem 2:

The other problem is that is does not appear to be possible to fetch the userid from the CRM, since the getuser API call (API v1) does not support an explicit connection.   This also means any efforts to perform user-specific activities from any Cliq function back into the CRM does not appear to be possible - or have I missed something?

Any help is very much appreciated.

Regards,
Joe



    • Sticky Posts

    • Customer payment alerts in Zoho Cliq

      For businesses that depend on cash flow, payment updates are essential for operational decision-making and go beyond simple accounting entries. The sales team needs to be notified when invoices are cleared so that upcoming orders can be released. In contrast,
    • Automating Employee Birthday Notifications in Zoho Cliq

      Have you ever missed a birthday and felt like the office Grinch? Fear not, the Cliq Developer Platform has got your back! With Zoho Cliq's Schedulers, you can be the office party-cipant who never forgets a single cake, balloon, or awkward rendition of
    • Accelerate Github code reviews with Zoho Cliq Platform's link handlers

      Code reviews are critical, and they can get buried in conversations or lost when using multiple tools. With the Cliq Platform's link handlers, let's transform shared Github pull request links into interactive, real-time code reviews on channels. Share
    • App Spotlight : PagerDuty for Zoho Cliq

      App Spotlight brings you hand-picked apps to enhance the power of your Zoho apps and tools. Visit the Zoho Marketplace to explore all of our apps, integrations, and extensions. In today's fast-paced world, seizing every moment is essential for operational
    • Automate your status with Cliq Schedulers

      Imagine enjoying your favorite homemade meal during a peaceful lunch break, when suddenly there's a PING! A notification pops up and ruins your moment of zen. Even worse, you might be in a vital product development sprint, only to be derailed by a "quick