Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 is what I did, you can eventually develop this to do more but I'm coding for this example and for this demonstration only (obviously replace the my_owner and my_app with your Zoho Creator owner and app name respectively) Update 2022: I've included the...

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

Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-a-html-entity-decoder.html

27 January 2022 Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " and obviously want to display these as decoded HTML entities. (Zoho if you're listening) Ideally, Zoho may add this to their...

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

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

06 July 2023 "payment_terms": -3, "payment_terms_label": "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generate an invoice. Please refer to the Zoho Books API documentation for what fields are...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 }); }); ZOHO.embeddedApp.init(); [Optional] What follows is the code for the function fn_Accounts_CreditSafe... obviously I can't give you the real Zoho Deluge function here as it would use my credentials but what you need to know is that it is passed...

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

If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/articles/microsoft/ssrs/if-then-else-in-report-builder-20-expressions.html

06 May 2010 Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0)...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://www.joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 (x.xmlval, '/rows/row'))) d Yields: 1 2 3 4 5 6 Note that I actually used text in the example above and this worked. Obviously don't get the commas mixed up.

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 on the first page. Every subsequent page simply displays the report header (which does not include the tablix header... obviously). I right-clicked on the header row of the tablix and checked the box "Repeat header columns on each page. Situation I have...

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