EntityDataLoader only works with CSV if the location ends with ".csv"
Opened this issue · 0 comments
eigood commented
The trailing '#extension.csv' is a hack, to get around the loadSingleFile extension checking logic. In an ideal situation, the resource facade would return a tuple, the contentType+inputstream of the target.
In the following url, key is the random sheet identifier, and gid is the sub-tab(default of 0 for the first tab that is created).
I don't have a patch at this time, as a proper fix would probably be quite a bit of code.
<script><![CDATA[
loader = ec.entity.makeDataLoader()
loader.csvEntityName(serviceName)
loader.location("https://docs.google.com/spreadsheets/d/${key}/export?format=csv&gid=${gid}#extension.csv")
loader.load()
]]></script>