Skip to main content
Question

Sharepoint & IQY file in FME

  • February 21, 2020
  • 0 replies
  • 77 views

pcheng
Contributor
Forum|alt.badge.img+8

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.