For Zoho Services only:


I'm actually part of something bigger at Ascent Business Solutions recognized as the top Zoho Premium Solutions Partner in the United Kingdom.

Ascent Business Solutions offer support for smaller technical fixes and projects for larger developments, such as migrating to a ZohoCRM.  A team rather than a one-man-band is always available to ensure seamless progress and address any concerns. You'll find our competitive support rates with flexible, no-expiration bundles at https://ascentbusiness.co.uk/zoho-services/uk-zoho-support.  For larger projects, talk to our experts and receive dedicated support from our hands-on project consultants at https://ascentbusiness.co.uk/zoho-services/zoho-crm-implementation.

The team I manage specializes in coding API integrations between Zoho and third-party finance/commerce suites such as Xero, Shopify, WooCommerce, and eBay; to name but a few.  Our passion lies in creating innovative solutions where others have fallen short as well as working with new businesses, new sectors, and new ideas.  Our success is measured by the growth and ROI we deliver for clients, such as transforming a garden shed hobby into a 250k monthly turnover operation or generating a +60% return in just three days after launch through online payments and a streamlined e-commerce solution, replacing a paper-based system.

If you're looking for a partner who can help you drive growth and success, we'd love to work with you.  You can reach out to us on 0121 392 8140 (UK) or info@ascentbusiness.co.uk.  You can also visit our website at https://ascentbusiness.co.uk.

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge

What?
A quick article on how to upload an image to the product/item listing in Zoho Inventory.

Why?
We're enhancing the out-of-the-box integration from eBay to Zoho Inventory bespoke for a customer. We want the photo on eBay to be downloaded and uploaded to the Zoho Inventory record for the respective record. As Zoho Books and Zoho Subscriptions uses the same database tables as Zoho Inventory, and there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books.

How?
We're not going to go into detail on how to parse an eBay response here (see my other articles on eBay webhooks). Instead, all we want is the URL of an image to be downloaded, then uploaded to the Zoho Inventory or Zoho Books item record.

Well I don't want to research this often so here's the quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list variable:
copyraw
l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList();

// yields
// https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567890,https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567891
  1.  l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList()
  2.   
  3.  // yields 
  4.  // https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567890,https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567891 
Note that for the below code, only 1 image is accepted at the moment, and the endpoint will depend on your datacenter (eg. COM or EU), and lastly the connection "joel_books" is my connection to ZohoBooks:

copyraw
//
// declare ID of item in Zoho Inventory
v_InventoryId = 123456789012345678;
//
// your organization ID (optional)
v_BooksOrgId = 20220621;
//
// download photo from eBay
r_DownloadedPhoto = invokeurl
[
    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 = "https://books.zoho.eu/api/v3/items/" + v_InventoryId + "/image?organization_id=" + v_BooksOrgId;
//
// updload the photo
r_UploadPhoto = invokeurl
[
    url :v_Url
    type :POST
    files:r_DownloadedPhoto
    connection:"joel_books"
];
// output response to console
info "Response of attempt to upload to Zoho Inventory:";
info r_UploadPhoto;
  1.  // 
  2.  // declare ID of item in Zoho Inventory 
  3.  v_InventoryId = 123456789012345678
  4.  // 
  5.  // your organization ID (optional) 
  6.  v_BooksOrgId = 20220621
  7.  // 
  8.  // download photo from eBay 
  9.  r_DownloadedPhoto = invokeUrl 
  10.  [ 
  11.      url :v_EbayPictureUrl 
  12.      type :GET 
  13.  ]
  14.  // 
  15.  // set the data type 
  16.  r_DownloadedPhoto.setParamName("image")
  17.  // 
  18.  // build up request to Zoho 
  19.  m_Params = Map()
  20.  m_Params.put("image",r_DownloadedPhoto)
  21.  // 
  22.  // generate endpoint 
  23.  v_Url = "https://books.zoho.eu/api/v3/items/" + v_InventoryId + "/image?organization_id=" + v_BooksOrgId; 
  24.  // 
  25.  // updload the photo 
  26.  r_UploadPhoto = invokeUrl 
  27.  [ 
  28.      url :v_Url 
  29.      type :POST 
  30.      files:r_DownloadedPhoto 
  31.      connection:"joel_books" 
  32.  ]
  33.  // output response to console 
  34.  info "Response of attempt to upload to Zoho Inventory:"
  35.  info r_UploadPhoto; 
You should get a response similar to the following:
copyraw
{"code":0,"message":"We've updated the item image. Nice one, by the way!"}
  1.  {"code":0,"message":"We've updated the item image. Nice one, by the way!"} 

Update 2024: Following Books Domain Upgrade
copyraw
//
// ZohoBooks Organization ID
v_BooksOrgId = 12345678;
//
// Zoho Books Item ID
v_ZB_ItemID = 123456000000789012;
// 
// download photo
v_ImageSrc = "https://picsum.photos/200";
r_DownloadedPhoto = invokeurl
[
	url :v_ImageSrc
	type :GET
];
// 
// set the data type 
r_DownloadedPhoto.setParamName("image");
// 
// generate endpoint 
v_Url = "https://www.zohoapis.com/books/v3/items/" + v_ZB_ItemID + "/images?organization_id=" + v_BooksOrgId;
// 
// updload the photo 
r_UploadPhoto = invokeurl
[
	url :v_Url
	type :POST
	files:r_DownloadedPhoto
	connection:"my_books_connection"
];
//
// output for demo purposes
info r_UploadPhoto;
  1.  // 
  2.  // ZohoBooks Organization ID 
  3.  v_BooksOrgId = 12345678
  4.  // 
  5.  // Zoho Books Item ID 
  6.  v_ZB_ItemID = 123456000000789012
  7.  // 
  8.  // download photo 
  9.  v_ImageSrc = "https://picsum.photos/200"
  10.  r_DownloadedPhoto = invokeUrl 
  11.  [ 
  12.      url :v_ImageSrc 
  13.      type :GET 
  14.  ]
  15.  // 
  16.  // set the data type 
  17.  r_DownloadedPhoto.setParamName("image")
  18.  // 
  19.  // generate endpoint 
  20.  v_Url = "https://www.zohoapis.com/books/v3/items/" + v_ZB_ItemID + "/images?organization_id=" + v_BooksOrgId; 
  21.  // 
  22.  // updload the photo 
  23.  r_UploadPhoto = invokeUrl 
  24.  [ 
  25.      url :v_Url 
  26.      type :POST 
  27.      files:r_DownloadedPhoto 
  28.      connection:"my_books_connection" 
  29.  ]
  30.  // 
  31.  // output for demo purposes 
  32.  info r_UploadPhoto; 
Base64
copyraw
//
// ZohoBooks Organization ID
v_BooksOrgId = 12345678;
//
// Zoho Books Item ID
v_ZB_ItemID = 123456000000789012;
// 
// download photo
v_ImageSrc = "https://picsum.photos/200";
r_DownloadedPhoto = invokeurl
[
	url :v_ImageSrc
	type :GET
];
v_DownloadedBase64 = zoho.encryption.base64Encode(r_DownloadedPhoto);
f_base64 = zoho.encryption.base64DecodeToFile(v_DownloadedBase64,"my_image.png");
// 
// set the data type 
f_base64.setParamName("image");
// 
// generate endpoint 
v_Url = "https://www.zohoapis.com/books/v3/items/" + v_ZB_ItemID + "/images?organization_id=" + v_BooksOrgId;
// 
// updload the photo 
r_UploadPhoto = invokeurl
[
	url :v_Url
	type :POST
	files:f_base64
	connection:"my_books_connection"
];
  1.  // 
  2.  // ZohoBooks Organization ID 
  3.  v_BooksOrgId = 12345678
  4.  // 
  5.  // Zoho Books Item ID 
  6.  v_ZB_ItemID = 123456000000789012
  7.  // 
  8.  // download photo 
  9.  v_ImageSrc = "https://picsum.photos/200"
  10.  r_DownloadedPhoto = invokeUrl 
  11.  [ 
  12.      url :v_ImageSrc 
  13.      type :GET 
  14.  ]
  15.  v_DownloadedBase64 = zoho.encryption.base64Encode(r_DownloadedPhoto)
  16.  f_base64 = zoho.encryption.base64DecodeToFile(v_DownloadedBase64,"my_image.png")
  17.  // 
  18.  // set the data type 
  19.  f_base64.setParamName("image")
  20.  // 
  21.  // generate endpoint 
  22.  v_Url = "https://www.zohoapis.com/books/v3/items/" + v_ZB_ItemID + "/images?organization_id=" + v_BooksOrgId; 
  23.  // 
  24.  // updload the photo 
  25.  r_UploadPhoto = invokeUrl 
  26.  [ 
  27.      url :v_Url 
  28.      type :POST 
  29.      files:f_base64 
  30.      connection:"my_books_connection" 
  31.  ]

Caveat(s)
  • The code above only uploads 1 photo... Update 2024: the code above STILL only uploads 1 photo.

Error(s) Encountered
  • {"code":37,"message":"The HTTP method POST is not allowed for the requested resource"} The endpoint is wrong (for example you don't need the organization ID parameter at the end of the URL)
  • {"code":2,"message":"The request passed is not valid."} The .setParamName() function is setting the data type to probably file or attachment when it should be image.
Category: Zoho :: Article: 814

Credit where Credit is Due:


Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

Related Articles

Joes Revolver Map

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF
© 2024 Joel Lipman .com. All Rights Reserved.