Informatica - POST data to REST API / SOAP Web Service (Upload XML / JSON File to HTTP URL)

[@AllaboutKpopAndBL]

Can we create this same process in informatica cloud? I want to take a real time data from user, and writes into a file. Is that possible?

[@pankajpabla]

Nice demo ! Could you please show or upload your 1.json file format

[@NAVEENKUMAR-lv7hg]

Can the same be designed using an HTTP or Java transformation?, I have a two way auth API which I need to Post data from Oracle. Let me know what can be the best approach? Thanks

[@ZappysysSoft]

Its possible but the video was all about how to avoid coding to integrate API data in Informatica. Depending on your API it may be simple or complex to call APi via Java Code. Some APi requires 3 legged OAuth or 2 steps dynamic token approach for Authentication before you can make API call. This makes it complex. Whih API are you trying to call .. do you have link to their API Help Page?

[@singhraunak09]

If i want to call Salesforce API into informatica Should i be downloading the Salesforce Driver or Zappysys driver will work for Salesforce API.? Please answer. Waiting for your kind response

[@ZappysysSoft]

If you just want to read salesforce table data then use our salesforce driver. If you like to call special operation not exposed by our salesforce driver (e.g. send mail action) then you can use JSON Driver or XML Driver to call any API action / parse response data in tabular format. JSON / XML driver supports OAuth connection which you can use to call Salesforce API. Check this link zappysys.com/blog/how-to-call-salesforce-rest-api-via-odbc-driver/

[@kabitaghosh1506]

Can you please show how to make put call in http transformation

[@hanumantharaochalla7443]

Hello JappySys, Nice Video, Thank you. Can you please help me on below? I have a requirement to call REST API of APIGEE gateway with an authentication token, API of Salesforce app, and JSON query to fetch the data. from Informatica (PC/Developer) Requirement background - Informatica app is installed in an internal host of the bank and the Public salesforce cloud is external to the bank. whenever data is transferring between internal and external systems, we have an authentication process(APIGEE Gateway). So PowerExchane for SalesForce plugin is not applicable here. Steps to do - first step : Call the CISO authentication system with REST API to receive a token. Second Step: Call REST API of APIGEE gateway with the below details- URL of APIGEE gateway Token from the first step API required to call SalesForce application JSON query to fetch required data from the SalesForce app. So need your help to achieve the above steps with the Informatica tools/with JappySys. Please suggest.

[@ZappysysSoft]

Yes its possible. There are few ways to pass token in ZappySys driver. You can configure HTTP connection method with Dynamic Token (2 Steps Auth). Here is example query. FYI - Most of these parameter in below query can be configured in UI buy you can also override any of those UI settings in runtime query (Totally optional) Query REST API (Dynamic Token Method) This example shows how to call REST API Service using Dynamic Token approach. Learn how to authenticate using userid / password to obtain temporary token which can be passed to call API. Also learn how to pass Body, Headers using HTTP POST. For more information about Dynamic Token visit zappysys.com/links/?id=10091 SELECT * FROM $ WITH( Src='zappysys.com/downloads/files/test/rest-getdata.aspx?format=json' ---,RequestMethod='POST' ---,RequestData='{sessionid: "[$token$]"}' ,Filter='$.rows[*]' ,Header='Content-Type: application/json || Accept: */* || Cache-Control: no-cache' ,DataConnectionType='HTTP' ,CredentialType='TokenDynamic' ,UserName='MyUser001' ,Password='P@$$w0rdAAc12' ,AuthScheme='{none}' ,TokenUrl='zappysys.com/downloads/files/test/rest-login.aspx' ,TokenRequestData='{ user:"[$userid$]", password:"[$password$]" }' ,TokenRequestMethod='POST' ,TokenResponseContentFilter='$.sessionid' ,TokenRequestHeaders='Content-Type:application/json | Accept:*/* | Cache-Control:no-cache' ,TokenResponseContentType='Json' ) --- Examples for Driver Query language --- zappysys.com/onlinehelp/odbc-powerpack/scr/json-odbc-driver-sql-query-examples.htm Contact ZappySys Support via Live Chat on website if you still cannot figure out (Click Bottom Right Corner chat icon)

[@karthik160592]

Hi I need to send data to rest api through http transformation in informatica. how do we send two fields as http request as below through informatica power centre [ { "id":"ohnn9innn" "ownerid":"cvv67nnmn" } ]