<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ extable ] failed in the evaluation of ???????????????????Mule ?????????[datasource] ?????????????????????????????? </p> <p> This article demonstrates how to use the [company_name] Mule Connector for [service] inside of a Mule project to create a Web interface for [datasource]. The application created allows you to request [datasource] using an HTTP request and have the results returned as JSON. The exact same procedure outlined below can be used with any [company_name] Mule Connector to create a Web interface for the [x|db('v_drivers_count.total.count')]+ available data sources. </p> <ol> <li>Create a new Mule Project in Anypoint Studio.</li> <li>Add an HTTP Connector to the Message Flow.</li> <li>Configure the address for the HTTP Connector. <img src='[x|UrlRootAbs]\kb\articles\mule-anypoint-studio-1.png' title='Add and Configure the HTTP Connector'/></li> <li>Add a [company_name] [service] Connector to the same flow, after the HTTP Connector.</li> <li>Create a new Connection (or edit an existing one) and configure the properties to connect to [service] (see below). Once the connection is configured, click Test Connection to ensure the connectivity to [service]. [extraconnectionnotesjdbc|def('[extraconnectionnotes|def(\'\')]')] <img src='[x|UrlRootAbs]\kb\articles\mule-anypoint-studio-2.png' title='Add the [company_name] [service] Connector and Configure the Connection (Salesforce is Shown)'/></li> <li>Configure the [company_name] [service] Connector. <ol type=a> <li>Set the Operation to 'Select with Streaming'.</li> <li>Set the Query type to Dynamic.</li> <li>Set the SQL query to <var>SELECT * FROM #\[message.inboundProperties.'http.query.params'.get('table')]</var> to parse the URL parameter <var>table</var> and use it as the target of the SELECT query. You can customize the query further by referencing other potential URL parameters.</li> </ol> <img src='[x|UrlRootAbs]\kb\articles\mule-anypoint-studio-3.png' title='Configure the [company_name] [service] Mule Connector (Salesforce is Shown)'/> </li> <li>Add a Transform Message Component to the flow. <ol type=a> <li>Map the Payload from the input to the Map in the output.</li> <li>Set the Output script to the following to convert the payload to JSON: <pre class="brush:js"> %dw 1.0 %output application/json --- payload </pre> </li> </ol> <img src='[x|UrlRootAbs]\kb\articles\mule-anypoint-studio-4.png' title='Add the Transform Message Component to the Flow'/></li> <li>To view your [datasource], navigate to the address you configured for the HTTP Connector (localhost:8081 by default) and pass a table name as the <var>table</var> URL parameter: <var>http://localhost:8081?table=[extable]</var> <br> The [extable] data is available as JSON in your Web browser and any other tools capable of consuming JSON endpoints.</li> </ol> <p> At this point, you have a simple Web interface for working with [datasource] (as JSON data) in custom apps and a wide variety of BI, reporting, and ETL tools. Download a <a href="[x|UrlRootAbs]\drivers/[id]/download/mule">free, 30 day trial</a> of the Mule Connector for [service] and see the CData difference in your Mule Applications today. </p>. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/sqlite-mule-anypoint-studio.rst