Create ODBC Connection for APIĬheck this section from previous article to learn how to configure API Connection using ZappySys ODBC Driver for JSON / XML / CSV. In the following demo we are trying to create new Customer records by calling POST API.įor that we will use following setup. So let’s get started with basic setup on how to POST data to your API to create new records or update / delete records. It also covers how to Upload File to Web API. Here is the full Video Tutorial with many API tips / tricks to show how to POST data to REST / SOAP API in Informatica PowerCenter. Video Tutorial – POST data to API in Informatica If nothing available then you can use flat file target. Access to a Relational database such as SQL Server (or use any of your choice e.g.Install Informatica PowerCenter Client Tools (e.g.Download Install ZappySys ODBC PowerPack (Drivers for JSON and REST API).This article assumes that you have full filled following basic requirements. REST or SOAP).įor example purpose we will use JSON API but if you are calling XML / SOAP API then use ZappySys XML Driver instead of JSON Driver. We will use SQL Transformation to fire ODBC Driver Queries to create / update or delete records in Target System by calling Web API (i.e. We will learn how to to POST data to API in Informatica (Insert / Update). In our previous blog post we saw how to read JSON REST API / XML SOAP in Informatica using ZappySys ODBC Drivers. 6 Debugging REST / SOAP API using Fiddler.5 Upload File to API (Read Body from Local File).4.4 Create Informatica Mapping to POST data to REST API / SOAP Web Service.4.3 Prepare POST Query and generate Metadata File.4.2 Create Relational Connection in Workflow Designer. 3 Video Tutorial – POST data to API in Informatica.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |