SSDN - trouble with download of pricestockfile

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Bruce Cantor

Subject: trouble with download of pricestockfile
Author: Bruce Cantor
Date: 14 Aug 2023 11:06 AM

Hi,

I have this simple xquery script that is supposed to download a csv file from a customer of ours. (URL modified in post to be able to post here)

declare variable $input_url := "https_//cloudmarkt.de/backend/export/index/CM_PREISLISTE_FH.txt?feedID=35&hash=xxxxxxxxxxxxxxxx";
declare variable $input_base64_url := concat("converter:BASE64?",$input_url);
declare variable $output_folder_url := "C:\tmp";
declare variable $output_file := "PriceAndStock.csv";
declare variable $output_url := concat($output_folder_url, $output_file);

ddtek:serialize-to-url(
doc($input_base64_url),
$output_url,
"method=BASE64")

This script fails with an error:

[DataDirect][XQuery]Error at line 7, column 1. Error in call to ddtek:serialize-to-url(): Illegal character in opaque part at index 2: C:\tmpPriceAndStock.csv

Can anybody tell me what I am doing wrong?

Is there an easier way to download such a file?

Kind regards Bruce

Ivan Pedruzzi

Subject: trouble with download of pricestockfile
Author: Ivan Pedruzzi
Date: 14 Aug 2023 02:53 PM

The second parameter of serialize-to-url is expected to be a url, you are al missing the path separator between folder and filename

declare variable $output_folder_url := "file:///C:/tmp";
declare variable $output_file := "PriceAndStock.csv";
declare variable $output_url := concat($output_folder_url, "/",$output_file);

Ivan Pedruzzi
Stylus Studio Team

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.