What?
I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room.
The Problem?
When I select specifying the statement "WHERE IN (c.RoomImages)", ...
... pages to retrieve every product from the WooCommerce system.
API connection in WooCommerce
So we need to get an API connection to ensure we get all the products. This involves getting a consumer_key ...
What?
A quick article on how to get around this error.
Why?
The use-case here is that I am using the send invoice API and I kept getting this error despite including the customer_id and there ...
... store this after the record is created/updated (was getting error if included in record creation - if in same row).
// c_ImageRow.File_field = f_DownloadFile;
//
// let's get the local ...
... zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error:
{
"code": 2945,
"description": "EXTRA_KEY_FOUND_IN_JSON"
}
How?
So the ...
What?
A quick article on getting the payment terms in Zoho Books along with their IDs.
Why?
I often need to send through an automatic payment term on the creation of an invoice but lots of my ...
... of Zoho Inventory. In this task, we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet.
How?
Similar to how we retrieved the eBay active listings (see ...
What?
A super quick article on getting the business hours set in ZohoCRM.
Why?
When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing ...
...
Getting to the development-side
Login to ZohoCRM as a super-admin
Go to Setup (cog icon in the top right)
Under Zia, select "Conversational AI"
Click on the link "Zia Developer Console" (yours ...
What?
Another one of these articles talking about getting all the active product listings from eBay for a specific client.
Why?
Our use-case scenario here is that we want to get an inventory ...
... function too often either for debugging/monitoring purposes but it's easier to use an access token then getting the OAuth access codes from the client.
How?
I'm going to split this into 2 code snippets ...
What?
A quick article to display a value in a column in a widget in Zoho Analytics.
Why?
Because I keep forgetting how to do it.
How?
I've done this for a query that amalgamated all the ...
... location, for that’s the email id you need to send files to for those to show up on your Kindle.
Getting your email ID approved
Just having your Kindle email address won’t suffice unless you ...
... How to Generate a Shopify Access Token (legacy)
Shopify Community - API To Search Products By SKU
Zoho Deluge: Push Item to Shopify API
Shopify .dev - Getting started with the GraphQL Admin and REST ...
... to say this is a strange issue and an even stranger fix, but I've tested this solution by getting a colleague to refresh the page and check it out as well as the client to go in and confirm the change was ...
... to run (this would initially attach the file to the CRM record). This wasn't working really as there are issues around tweaking the function and getting it to understand basic mapping and attachments. ...
... articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge: Get Image Uploaded in Creator Form which has one method of getting a public link.
...
... = ifnull(r_ShopifyProduct.get("variants").get(0).get("sku"), "UNKNOWN");
m_Sku_IDs.put(v_ProductSKU, r_ShopifyProduct.get("id"));
//
// getting the last ID from the Shopify sort instead of making ...
...
Auth'n'auth (Authentication and Authorization) Process
Not getting notification via the URL but you are getting them via email? Well I read somewhere you need to use Auth'n'auth to enable these notifications ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.