Hi @natehewes13, I looked at the HTML source document and found that the required data are stored in two <table> elements, which can be identified by their class names - "GroupBox1" and "DataGrid" and therefore you can extract the <table> elements with the HTMLExtractor.
However, unfortunately, the current HTMLExtractor doesn't support to identify class names containing upper case characters (FME 2017.0). It's a known issue and I hope this will be fixed in the near future.
As a workaround in the interim, change "GroupBox1" and "DataGrid" within the response body to lower case (StringReplacer can be used), then extract the two <table> element using the HTMLExtractor with this setting. You can then parse the extracted <table> elements as XML fragments.
Additionally, if you want to create a working hyperlink in Excel, you will have to create two attributes:
1. 'View Form/Attachment' with value 'View'
2. 'View Form/Attachment.hyperlink' with the URL of the hyperlink.
Only the first must be used as an attribute in the writer. The .hyperlink is explained for the Reader but not for the Writer.
One thing to keep in mind: there is a limit of 66530 hyperlinks per worksheet. (excel specs)
Hi @natehewes13, I looked at the HTML source document and found that the required data are stored in two <table> elements, which can be identified by their class names - "GroupBox1" and "DataGrid" and therefore you can extract the <table> elements with the HTMLExtractor.
However, unfortunately, the current HTMLExtractor doesn't support to identify class names containing upper case characters (FME 2017.0). It's a known issue and I hope this will be fixed in the near future.
As a workaround in the interim, change "GroupBox1" and "DataGrid" within the response body to lower case (StringReplacer can be used), then extract the two <table> element using the HTMLExtractor with this setting. You can then parse the extracted <table> elements as XML fragments.
The issue where upper case characters are not allowed for class names has been addressed and should be allowed in FME 2017.1 build 17504.
The issue where upper case characters are not allowed for class names has been addressed and should be allowed in FME 2017.1 build 17504.
Good to hear
Thanks for the update, @stephenwu.
Hi @natehewes13 ,
Could you please provide another link? I just want to check on the consistacy of the tags.
Thanks.
Lyes
Hi @natehewes13, I looked at the HTML source document and found that the required data are stored in two <table> elements, which can be identified by their class names - "GroupBox1" and "DataGrid" and therefore you can extract the <table> elements with the HTMLExtractor.
However, unfortunately, the current HTMLExtractor doesn't support to identify class names containing upper case characters (FME 2017.0). It's a known issue and I hope this will be fixed in the near future.
As a workaround in the interim, change "GroupBox1" and "DataGrid" within the response body to lower case (StringReplacer can be used), then extract the two <table> element using the HTMLExtractor with this setting. You can then parse the extracted <table> elements as XML fragments.
This worked great! Thank you @takashi (and sorry this post is so late).
