Yes, I’ve read the other posts about this topic
But I'm rather unlucky getting it to work. Each time I press the ‘Test Connection' it fires a GET method at the URI, which results in the infamous ‘The requested resource does not support http method 'GET'’ message.
RSD file:
==================================
<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<!-- See Column Definitions to specify column behavior and use XPaths to extract column values from JSON. -->
<api:info title="Table1" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">
<!-- You can modify the name, type, and column size here. -->
<attr name="_RowNumber" xs:type="string" readonly="false" other:xPath="/json/_RowNumber"/>
<attr name="Assignee" xs:type="string" readonly="false" other:xPath="/json/Assignee"/>
<attr name="Date" xs:type="date" readonly="false" other:xPath="/json/Date"/>
<attr name="Row_ID" xs:type="string" readonly="false" other:xPath="/json/Row ID"/>
<attr name="Status" xs:type="string" readonly="false" other:xPath="/json/Status"/>
<attr name="Title" xs:type="string" readonly="false" other:xPath="/json/Title"/>
</api:info>
<api:set attr="DataModel" value="DOCUMENT"/>
<api:set attr="URI" value="https://api.appsheet.com/api/v2/apps/a92d1c56-938f-45ac-bc00-c637f37a1a60/tables/Table%201/Action"/>
<api:set attr="JSONPath" value="$."/>
<!-- The GET method corresponds to SELECT. Here you can override the default processing of the SELECT statement. The results of processing are pushed to the schema's output. See SELECT Execution for more information. -->
<api:script method="GET">
<api:set attr="method" value="POST"/>
<api:set attr="contenttype" value="application/json"/>
<api:set attr="data">{"Action": "Find","Properties": {"Locale": "nl-NL"}}</api:set>
<api:call op="jsonproviderGet">
<api:push/>
</api:call>
</api:script>
</api:script>
================================
Instructions how to read a AppSheet Database: https://support.google.com/appsheet/answer/10105770?hl=en
I got it to work in Postman (please develop a postman import-functionality btw, that would make life so much easier!)


