Search - Joel Lipman .Com

1. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the record: / Zoho /; What? A super quick article to demonstrate how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). ...; Created on 26 July 2021
2. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; ... pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" ...; Created on 05 December 2013
3. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; What? This is an article to show how to setup a scheduled function that checks and restores a missing webhook as well as the snippets when receiving the webhooks and storing them. Why? We found ...; Created on 22 April 2024
4. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... + v_Page); // maximum number of products per page l_PaginationParams.add("per_page=" + v_PerPage); // missing products if using default order by as date l_PaginationParams.add("order=asc"); l_PaginationParams.add("order_by=id"); // r_AllProduct ...; Created on 15 April 2024
5. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... from a public domain, no user wall. The key here which the official documentation is missing is the .setParamName() but for those who have spent time to find this function, they'll already know this. ...; Created on 20 July 2023
6. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... for anything else than tracking stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory ...; Created on 04 May 2023
7. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... ":}]} I only resolved this by not using "endCursor" in my GraphQL and instead looped through the nodes to get the last cursor. Not sure if this meant any data was missing. Perhaps by forcing the sort cr ...; Created on 20 February 2023
8. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; What? This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module ...; Created on 08 February 2023
9. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... missing associated purchase orders altogether. I had to break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine the cost ...; Created on 03 November 2022
10. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... to speak to someone from eBay. Done! Error(s) Encountered 22112 - Missing property name or event type: Could have been many things. For me it was because I was submitting an EventType in the ...; Created on 20 September 2021
11. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... = 34 hours and 6 minutes). Error(s) Input Parameter Missing (6831): Can happen when there are either too many parameters or one is missing. Instead of abiding by the API documentation which wa ...; Created on 30 April 2021
12. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... type: npm install –g zoho-extension-toolkit If you get errors like “Missing write access to/usr/local/lib/node_modules” then type the following instead: sudo npm install –g zoho-extension-toolkit You ...; Created on 24 October 2020
13. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... Statement Error might be due to missing ';' at end of the line or incomplete expression This could be a missing semi-colon somewhere in your code OR that you have included either "content-type" in your ...; Created on 15 May 2020
14. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... value is "2020-02-10T11:49:12+0100" // yields ,"message":"invalid data","status":"error"} Solution: The above ALMOST works for API and Deluge Shortcode, but we're missing the colon in the TimeZone value: ...; Created on 06 February 2020
15. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... = invokeUrl [ url :v_EndPoint type :PUT headers: m_Header parameters:m_Data // MISSING .toString() to convert this ensuring it is not a list or map ]; ,"message":"Authtoken support is deprecated","status":"error"} ...; Created on 17 July 2019
16. Deserialization and cannot checkout files in TFS: / Team Foundation Server /; Why? So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those ...; Created on 03 January 2013
17. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... the second based on the first will error this procedure. One Issue I just kept getting this error over and over again: ORA-00936: missing expression 00936. 00000 - "missing expression" The ...; Created on 24 January 2012
18. T-SQL Record Separator: / Transact-SQL /; ... query for a timetabling solution with spacing rows between days. This worked ok but pay special attention to Stage #3 afterwards otherwise if you stop in Stage #2 you'll be missing data: --Create CTE WITH ...; Created on 11 October 2011
19. Joes Quicklist Weblinks (JQW): / Product Documentation /; ... Thumbnail Yet? If the thumbnail hasn't been generated and you have opted to display thumbnails, then a placeholder indicating a missing image will display. You can create a "no_thumbnail_yet" image (i ...; Created on 03 July 2011
20. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparison: / Joomla /; ... YooTheme Nice graphics and nice templates but there's something bland and missing. The YooTools are interesting but as with a lot of showroom demo ...; Created on 08 April 2010