I see a response returned from the web service, but the preview in REST Source does not show any data.
CozyRoc Rest Source Component allow you to Read data from REST API. Developer can quickly extract response data from desire endpoint using HTTP Method (GET, POST) and Output into column data. In this article we will walk through some examples that will include defining Fields and Result Extraction using the Payload receive in response from RESTful API.
Use Case 1
Response from REST API
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
How to implement paging in the Custom REST Configuration Editor.
There is a demonstration video that explains three different pagination templates available in the Custom REST Configuration Editor. This demonstration video only shows a brief overview that the templates are available and how they can be used to ...Will the Dynamics 365 Connection be updated to include support for global discovery service?
The new global Discovery Service is not supported with the legacy SOAP protocol that our Dynamics CRM Connection uses. Going forward Microsoft has said to use Microsoft Dataverse (formerly known as Microsoft Common Data Services). In COZYROC SSIS+ ...REST Source: How to modify the [REST Source].[ResourceParameter] and [REST Source].[Resource] properties dynamically at runtime
Modify [REST Source].[Resource] dynamically at runtime: The source resource and filters are available in the data flow properties list. Follow these steps to set up an expression: Create a variable that contains the name of the Resource to be ...How to flatten composite records from Rest Source
Many real-world applications need to handle data structures which can't be represented with a simple flat table. A good example is an invoice record where each record contains a sub-list of line item records. For each main object, which identifies ...How to use a Database storage for new REST tokens
Make sure you have launched Visual Studio as "Run as Administrator". 1 : In Rest Connection Manager choose the configuration from the dropdown list you want to generate token for. 2: For the Token storage parameter in the grid below select Database ...