Question

Sharepoint & IQY file in FME

  • 21 February 2020
  • 0 replies
  • 3 views

Badge +2

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!

Reply