Search - Joel Lipman .Com

1. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... // resolve connection details if(!isNull(r_ShopifyConnection.get("data"))) { m_Data = r_ShopifyConnection.get("data"); v_ShopifyID = ifnull(m_Data.get("Shop_ID"),""); v_APIVersion = ifnull(m_Data.get("API_Version"),""); v_AccessTo ...; Created on 22 April 2024
2. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; What? A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function ...; Created on 04 October 2023
3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... or create. - Loop through eBay payments to record all the different payments received. Date Modified: 2023-03-14 (Joel Lipman) - Resolved fix of incorrect customer (Use Email rather than ...; Created on 27 April 2023
4. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
5. ZohoBooks: Stripe Terminal Integration: / Zoho /; What? A quick article on some code added to a button in ZohoBooks off the invoice module to initiate your Stripe terminal to take a payment. Why? Just to make it easy on the staff at a counter ...; Created on 16 March 2023
6. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; What? An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most ...; Created on 20 February 2023
7. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... number - Resolved: Do not url encode from and to phone numbers (also do not url encode the body/message). Number is formatted to E.164 [+] [country code] [subscriber number including area code] and can ...; Created on 16 December 2021
8. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; What? This is an article to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating ...; Created on 29 July 2021
9. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... Line Item Tax does not submit in API v2.1 Trial and error resolved this one. Submit the line item but instead of "line_tax", replace this with "Line_Tax" (note the capitalized letters). I have included ...; Created on 17 May 2021
10. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... out of date at time of print, trial and error will resolve this or use our examples above. // fields required if submitting time log without start time (uses current time and adds hours to it) - date ...; Created on 30 April 2021
11. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... fex["_FileTimeM"] := A_LoopFileTimeModified } Break } If Not ( _FileExt ) ; Filepath not resolved { Return ...; Created on 07 August 2020
12. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... perform this operation This is a quick issue to resolve as it may be incorrect scopes specified but in my case is more than often the wrong accounts server: v_DataEndpoint = "https://books.zoho.com/api/v3/contacts?organization_id=123456789"; r_Response ...; Created on 06 February 2020
13. Zoho Deluge - Update Creator from CRM: / Zoho /; What? This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where ...; Created on 18 February 2019
14. Zoho Inventory Template Issue: First Page is Blank: / Zoho /; What? So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product ...; Created on 15 November 2018
15. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
16. Android: Function to let user take photo or choose existing: / AndroidOS /; ... MediaStore.ACTION_IMAGE_CAPTURE); if (takePictureIntent.resolveActivity(getPackageManager()) != null) { startActivityForResult(takePictureIntent, REQUEST_IMAGE_CAPTURE); ...; Created on 04 November 2014
17. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; What? This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation ...; Created on 23 April 2013
18. DataTumble - Randomize Data Rows: / Transact-SQL /; ... and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble). How? CREATE PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName ...; Created on 07 December 2012
19. Background Gradient Disappears on Long Pages: / Cascading Stylesheets /; What? This is a quick article on how to resolve the following issue: Overall body background color is blue. Background color of my contents is white. When I visit a small page on the site, the ...; Created on 20 November 2012
20. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... Fixing this resolved all 3 issues below!!! Encountered Issues ORA-01403 no data found & ORA-06512 something else - Fixed by specifying the query parameter properly (ex: Parameter name = p_STUDENT_ADNAME, ...; Created on 19 January 2012