Skip to main content
Question

Sharepoint & IQY file in FME

  • February 21, 2020
  • 0 replies
  • 47 views

pcheng
Contributor
Forum|alt.badge.img+3

Hey FMErs!

 

Wondering if anyone here has worked with an Internet Query (.IQY) file downloaded from a sharepoint site before!

 

When I open the link in a web broswer (IE11 in this case) it'll prompt a download for this IQY and it'll resolve into a excel spreadsheet! 

 

I want to run a automated process on this file from FME but when I use use a XLS reader or HTTPCaller transformer all I've been getting are error messages or the 'GET' response:

(left out some details as its internal)

WEB
1
https://xxxxx
Selection={7EB5B6E8-8458-4F92-925E-A3EB593229E7}-{9814593B-164C-4604-A5DD-4CAF07C9FDF7}
EditWebPage=
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=https://xxxxx/_vti_bin
SharePointListView={9814593B-164C-4604-A5DD-4CAF07C9FDF7}
SharePointListName={7EB5B6E8-8458-4F92-925E-A3EB593229E7}
RootFolder=

Thanks in advanced,

 

Patrick

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings