How to convert a date into a usable date string that takes into account the timezone so that you can use it with the API
When you provide a date to the API to get records based on that date, be sure to convert the date used in the search criteria to a specific timezone. Using UTC is a good idea. Something that has worked for others is to convert the date to a String and then adjust to UTC.
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
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 ...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 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 ...Where can I find the documentation for the REST Source component?
You can find documentation related to all the COZYROC SSIS+ Suite components from the main products page. Specific documentation for the REST Source can be found at the following link. For many of the components, you can find an overview, ...How to use Postman Collections in COZYROC SSIS+ REST framework?
To use a Postman Collection, you will need first to convert it to an OpenAPI specification and then import it, as shown here: https://www.cozyroc.com/ssis/rest-custom-openapi-import There are various methods for this transformation, e.g. check out ...