resourceRules.xml

[Philippe Creytens]

Based on the number of posts here and the crappy online documentation, I am getting more and more convinced that SDC is hardly used.

Anyway, I have been trying to follow the documentation, especially on how to connect to a CSV that is on an intranet server.

This resourceRules.xml allows me to display the content of a CSV into a Private Gadget, but importing the data into a Google Spreadsheets does not work unless I add 'debug=text' to the import formula: =importData("http://10.226.53.200/contacts.csv?debug=text")

What is wrong with the config?

<resourceRules>

  <rule repeatable="true">

    <ruleNum>1</ruleNum>

    <agentId>agent1</agentId>

    <viewerEmail repeatable="true">us...@domain.com</viewerEmail>

    <apps repeatable="true">

      <service>Gadgets</service>

      <appId>http://feedserver-enterprise.googleusercontent.com/a/domain.com/g/PrivateGadgetSpec/myGadget.xml</appId>

      <allowAnyAppId>true</allowAnyAppId>

    </apps>

    <url>http://10.226.53.200/contacts.csv</url>

    <urlMatch>URLEXACT</urlMatch>

  </rule>

 <rule repeatable="true">

    <ruleNum>2</ruleNum>

    <agentId>agent1</agentId>

    <viewerEmail repeatable="true">us...@domain.com</viewerEmail>

    <apps>

      <service>Spreadsheets</service>

      <allowAnyAppId>true</allowAnyAppId>

    </apps>

    <url>http://10.226.53.200/contacts.csv</url>

    <urlMatch>URLEXACT</urlMatch>

  </rule>

</resourceRules>