topic Re: Qlikview RestConnector - Cannot parse data in selected response type in QlikView

Qlikview RestConnector - Cannot parse data in selected response type

bkozisek5r — Mon, 26 Jan 2026 16:26:21 GMT

This is my first time trying to use the RestConnector so this hopefully is a simple step i'm missing. I am trying to connect to USDA AMS data mart and the connection tests good. However when i try and select data, choosing XML as this is what the USDA documentation states as the return format I am receiving the following error: "Cannot parse data in the selected response type. Check the "Response Type" parameter value. XML was not Found"

The USDA documentation i am working with is http://marketnews.usda.gov/USDA-LMR-WebService-Client-User-Guide-v1_prod.pdf.

Thank you in advance for any assistance you may have.

Re: Qlikview RestConnector - Cannot parse data in selected response type

petter — Sat, 07 Jul 2018 17:52:33 GMT

I get data back without problem trying one of the example URLs in the USDA documentation. No error message just the expected data coming into QlikView.

I used this URL https://mpr.datamart.ams.usda.gov/ws/report/v1/cattle/LM_CT100?filter=%7b%22filters%22:%5b%7b%22fieldName%22:%22Report%2…

and several others and I got no error messages. Could you describe closer what you actually filled out where?

Re: Qlikview RestConnector - Cannot parse data in selected response type

bkozisek5r — Mon, 09 Jul 2018 14:59:58 GMT

I was trying to use just this portion in the URL https://mpr.datamart.ams.usda.gov/ws/report/v1/cattle/LM_CT100

And then the report date in the parameters section.

Thank you for your response. I am also getting it to work using the full URL with the report date selection included.

Re: Qlikview RestConnector - Cannot parse data in selected response type

bkozisek5r — Mon, 09 Jul 2018 15:18:14 GMT

Sorry, One more question. Could you help me with the proper way to make the URL dynamic so that i can have it auto refresh and pickup the new information each day?

Thanks

Brandi

Re: Qlikview RestConnector - Cannot parse data in selected response type

petter — Fri, 13 Jul 2018 13:30:51 GMT

You can use variables in the load script and do a $-sign expansion within the connection string to get the date dynamic (or any other part of the connection string actually).

vDate = Date(Now(1),'MM/DD/YYYY');

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://mpr.datamart.ams.usda.gov/ws/report/v1/cattle/LM_CT100?filter%2%%7b%%22filters%%22:%%5b%%7b%%22fieldName%%22:%%22Report%%20date%%22,%%22operatorType%%22:%%22EQUAL%%22,%%22values%%22:%%5b%%22$(vDate)%%22%%5d%%7d%%5d%%7d;timeout=30;method=GET;sendExpect100Continue=True;autoDetectResponseType=true;checkResponseTypeOnTestConnection=true;keyGenerationStrategy=0;authSchema=anonymous;skipServerCertificateValidation=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;XUserId=cPKQXOC;XPassword=PTVSGXA;";

The Connection String use a special kind of URL encoding where:

character	substituted
=	%2
{	%%7b
"	%%22
[	%%5b
<space>	%%20
]	%%5d
}	%%7d

Re: Qlikview RestConnector - Cannot parse data in selected response type

petter — Mon, 16 Jul 2018 22:58:42 GMT

If this answered your question please mark the answer as correct