ZohoDeluge: eBay marketplace account deletion/closure notificationshttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 eBay allows users to request the deletion of their personal data from eBay's own systems, as well as from the systems of all partners who store or display that data, including third-party developers integrated with eBay APIs through the eBay Developers...

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

Anti-Spam override for all submitted datahttp://mail.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 usually do when you modify a server-side file... ahem... The code by to look for (joomla default) should be as follows: $_REQUEST['tmpl'] = 'component'; include('index.php'); There is some more text but it's in /* lines */ which means these are...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a...

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

Things to Check if Joomla Password Reminder email not being senthttp://mail.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 system emails out on password change. The default if you’ve lost it is as below (exclude the double-quotes): “Hello,\n\nA request has been made to reset your %s account password. To reset your password, you will need to submit this verification code in...

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

Submit form as a server and not the client with cURLhttp://mail.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 PHP (LAMP) setups. Why? A customer wanted to connect their Mobile App to a third-party API. The third-party only accepts requests from a static and permitted IP address. If the end-user were to make the request, then their own IP address would be the...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho CRM: Update a custom field in line items / product details using REST API v2.1http://mail.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 Which when converted and sent in JSON would look something like the following request: { "Subject": "My Test Quote", "Product_Details": [ { "product": { "Product_Code": "TEST1", "Currency": "GBP", "name": "My Test Product", "id": "123456789012345678" },...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.http://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678",...

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

Zoho Creator: eBay: Get Item Transactionhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the XML of a GetItemTransactions request to eBay. How? You'll need an access token for eBay which I documented on how you can generate one in my article: Zoho...

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

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

14 February 2022 otherwise leave blank (eg. "123456789") Location Code if you know it (eg. "GB") Get access to the Shopify Admin Interface: Request access to the Shopify store owner as a developer Login to the Client's Shopify Admin as an invited developer Click on...

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

Zoho CRM: Schedule a Meeting using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 an Event using Zoho Deluge. Why? Because at time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of code to remind me. How? Similar to...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 / public URL of the file Get Zoho CRM to scan Creator for the public URL and retrieve this Get Zoho CRM to generate an XML request to upload the photo to eBay's Hosted Picture Services Get Zoho CRM to parse the eBay response and return the eBay hosted...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 [ url :v_EbayPictureUrl type :GET ]; // // set the data type r_DownloadedPhoto.setParamName("image"); // // build up request to Zoho m_Params = Map(); m_Params.put("image",r_DownloadedPhoto); // // generate endpoint v_Url =...

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

ZohoCRM: Get All eBay Active Listingshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // info "Request Sent to eBay:"; // info x_Params; // // send the request XML as a string x_ResponseBody = invokeurl [ url :v_Endpoint type :POST...

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

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

29 March 2023 x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //info "Request Sent to eBay:"; //info x_Params; // // send the request XML as a string x_ResponseBody = invokeurl [ url :v_Endpoint type :POST...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 payment records... Why? I'm storing this here as a reference and taking the bits that I need for the various clients that request an eBay integration. This is a comprehensive snippet which does the whole lot. How? Using the method of "mega-functions",...

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

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

02 October 2023 we'll use the last record used initally to generate this CSV/Text file; which happens to be a bill: // // build attachment request m_Attachment = Map(); m_Attachment.put("paramName", "attachment"); m_Attachment.put("content", f_BillsExport); // // this...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync http://mail.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 URL (website address) and take the number directly after "org-details/" v_AnalyticsOrgID = "20240702123"; // // generate request header m_Header = Map(); m_Header.put("ZANALYTICS-ORGID",v_AnalyticsOrgID); // // generate the endpoint to read the...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 v_ZA_WorkspaceID = "123456000000789012"; v_ZA_ViewID = "123467000009876543"; v_ZA_OrgID = "20240709007"; // // build up request to send m_Header = Map(); m_Header.put("ZANALYTICS-ORGID",v_ZA_OrgID); m_Params = Map();...

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

Zoho Projects: Get All Eventshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 are events in the past and "Open" are events in the future. The "is_open" in tasks is misleading and cannot be used in the request for events. There are hardly any parameters you can send to. Here's some code to get the last 50 events: // //...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 name): // // initialize b_ValidResponse = false; v_EstimateID = "-"; v_OrgId = "123456789"; v_Output = "Unable to process request"; // // evaluate v_Intent = ifnull(input.p_Intent,"-"); v_QuoteRef = ifnull(input.p_QuoteRef,"-"); v_CustomerID =...

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