Issue with Fetching Data from Zoho Creator using Custom Outlook Add-in

Issue with Fetching Data from Zoho Creator using Custom Outlook Add-in

Hi Team,

I am encountering an issue while trying to fetch data from Zoho Creator in a custom Outlook add-in. The goal is to retrieve origin and destination information from a specific report, but I'm facing CORS-related errors and failed requests.

Error:

Code Overview: Here’s the code snippet I'm using to make the API call:

  2. const fetch = require('node-fetch');

  4. const apiHeaders = {
  5.     "Authorization": "Zoho-oauthtoken xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
  6.     "Cookie": "ZCNEWUIPUBLICPORTAL=true; _zcsr_tmp=ac274c10-0020-4270-9587-795401481110; zalb_442b5845d7=16c37b275de039e0bf53479b8856aa88; zccpn=ac274c10-0020-4270-9587-795401481110"
  7. };

  9. async function fetchData() {
  10.     try {
  11.         const response = await fetch("https://www.zohoapis.com/creator/v2.1/data/OWNER_NAME/APP_NAME/report/REPORT_NAME", {
  12.             method: "GET",
  13.             headers: apiHeaders
  14.         });

  16.         if (!response.ok) {
  17.             throw new Error(`HTTP error! status: ${response.status}`);
  18.         }

  20.         const data = await response.json();
  21.         //console.log('API Response:', JSON.stringify(data, null, 2)); // Inspect structure

  23.         // Adjust the extraction logic based on the actual structure of the response
  24.         const origins = [];
  25.         const destinations = []

  27.         // Assuming the structure includes a 'data' key that contains the relevant items
  28.         if (data.data) {
  29.             data.data.forEach(item => {
  30.                 if (item.Origin) {
  31.                     origins.push(item.Origin);
  32.                 }
  33.                 if (item.Destination) {
  34.                     destinations.push(item.Destination);
  35.                 }
  36.             });

  38.             // Remove duplicates and sort the origins
  39.             const uniqueOrigins = [...new Set(origins)];
  40.             const sortedOrigins = uniqueOrigins.sort();

  42.             const uniqueDestinations = [...new Set(destinations)];
  43.             const sortedDestinations = uniqueDestinations.sort();

  45.             console.log(sortedOrigins);
  46.             console.log(sortedDestinations);
  47.         } else {
  48.             console.error('Data structure does not contain expected keys:', data);
  49.         }
  50.     } catch (exception) {
  51.         console.error(exception);
  52.     }
  53. }

  55. fetchData();

Context:

  • The API call works fine in tools like Postman, but when I try to run it in the custom add-in, I get the above errors.
  • I suspect it’s related to CORS issues, but I’m unsure how to proceed given the setup.

Could anyone suggest how to handle CORS in this context or point out if there's something wrong with the API call configuration? Is there a server-side configuration in Zoho Creator or any other workaround that could help?

Thanks in advance!