Add attribute xsl:nil=true on empty elements using XSLThttps://joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 element so that it's tag displays "xsi:nil=true". If...then...else... will be emulated by the XSLT choose...when...test...otherwise: true true -- yields: assuming value of DATE_OF_BIRTH is blank or null yields Done!

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 Did I miss anything? So none of the above worked. If there is another solution out there, I didn't find one that worked otherwise I'd have included it in this article. How? The fix is a PHP one and has to do with versions of PHP and MySQL. As quoted by...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 > 5){ $access_token = base64_decode(file_get_contents($api['jwt']['token']['file'])); }else{ Otherwise, let's generate a new access token. 6b. Get the contents of Google's JSON Key This key doesn't just contain the private key we need. It is a JSON file...

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

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 put either. Or your request is missing a field that is required by your CRM (is set to mandatory for users to enter data). Otherwise: m_Data = Map(); m_Data.put("JSONString",m_RecordData.toJSONList()); // change JSONString to data r_RecordUpdate =...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 an additional field called "eTag_Title", check if the new MD5 is different, if it is then I proceed with the automations otherwise I stop it. // get given eTag v_eTag = zoho.encryption.md5(input.Title.trim()); // // now compare to stored eTag if(v_eTag...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 Give it an API version (eg. "2022-01" - or whichever is the latest stable version) Location ID if you know it, otherwise leave blank (eg. "123456789") Location Code if you know it (eg. "GB") Get access to the Shopify Admin Interface: Request access to...

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

Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 // put the arguments into a single row (json array) json_Row.push(json_Arg); // need to stringify AND parse otherwise this won't work var json_Parsed = JSON.parse(JSON.stringify(json_Row)); // set new subform rows...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 c_ExistingDocument.Document_File; I have all of the above in the same function. I've split it out to explain parts but otherwise it is intended to be all in the same function as there are references to some variables in earlier snippets of code on this...

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

Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 Ensure the scope for your connection includes WorkDrive.teamfolders.READ and note that header has to be added otherwise you get a blank response: m_Header = Map(); m_Header.put("Accept","application/vnd.api+json"); v_Endpoint =...

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

Live WebCam feed of Bournemouthhttps://joellipman.com/articles/web-development/live-webcam-feed-of-bournemouth.html

30 January 2013 calming view... Note: I think this is running in British Summer Time (BST) rather than GMT or it's clock is seriously off. Otherwise it's a picture from the future (see photo timestamps).

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *