Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs (ErrCode: 21917182) - Modified to check that there are some orders. More Info: - API Explorer Test Tool:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Get Invoice Payment Terms via APIhttps://joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 the creation of an invoice but lots of my clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Generate Bank Text File for Downloadhttps://joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 extras Just making a list of things that at-time-of-print of this article aren't in the official Zoho documentation: Query the documents folder r_MyDocuments = invokeurl [ url: "https://www.zohoapis.com/books/v3/documents?organization_id=123456789"...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 deal record. Why? Anything that stumps me for 30 minutes is worth writing a quick article on. In this case, I had a function querying tags on a contact record which needed to be copied to a deal record. I wanted to copy over the tag but apparently, the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Converting SQL date in PHP to European date format and vice-versahttps://joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 The Solution This is what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-",...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Comparing two mediawiki siteshttps://joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 I guess I'm a bit geekly like that) This doesn't show modified date and content size differences but I can run this SQL query to show me these.

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider the following query: SELECT rb.[GivenDate] , rb.[DateStart] , rb.[DateFinish] , rb.[ContactUsername] , rb.[ContactName] , rb.[Room] ,...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Strip HTML in MySQLhttps://joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the query. The function that did work errored persistently complaining about the delimiter, create the function by running the...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SQL: Use CASE for Relevance columnhttps://joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Zoho Deluge - Get User Timezone, Country and Locationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 v_Response = getUrl( v_Url ); // usage: v_TimeZone = v_Response.getJSON("timezone"); Returns something like: { "query": "147.188.254.175", "status": "success", "continent": "Europe", "continentCode": "EU", "country": "United Kingdom", "countryCode":...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB