Extracting data from a NetSuite .iqy URL directly into KNIME without Excel

KNIME Analytics Platform
1

Is any way to retrieve data from a NetSuite .iqy URL directly inside KNIME, and have it refresh automatically without relying on Excel.

2

Hi,
this sound like a query you can pass directly into you favorite LLM like chatGPT or Gemini. This is the result

Yes — you can retrieve data from a NetSuite .iqy URL directly in KNIME without needing Excel, and you can set it up so the data refreshes automatically. The .iqy file from NetSuite is basically just a web query URL with parameters & cookies/tokens — Excel uses it to fetch data, but KNIME can do the same as long as you handle authentication and HTTP properly.

:brain: What’s inside a NetSuite .iqy file?

A typical NetSuite .iqy contains something like:

WEB
1
https://system.netsuite.com/app/reporting/...

So it is just an HTTP GET request. KNIME can fetch such URLs via its HTTP nodes — but you need to handle:

:check_mark: Authentication (often Token-Based Auth for NetSuite)
:check_mark: Session or OAuth signatures
:check_mark: Possibly cookies, headers, and query parameters

:white_check_mark: Option 1 — Use KNIME’s GET Request / POST Request Nodes

…

2 Likes
3

Thanks ActionAndi,

I already searched in Gemini AI, but could you please show me a visual example to demonstrate the steps?
Thank you in advance.