0

My team is trying to configure an Informatica job that pulls data from the SurveyCTO API. According to the documentation, the output is in CSV or JSON format.

I've seen this video and it looks like it's using ODBC to configure a JSON driver.

Is there a more direct / native way to connect to the API in Informatica? How can I setup the Informatica job to pull the data directly from the API?

Update
We were able to find the API Connector in our cloud PowerCenter and are trying to configure the Swagger file. We successfully created a Swagger file for a public API, but were unable to do so for our SurveyCTO API. We get an invalid URL error:

enter image description here

The SurveyCTO API URL is valid -- we tested it and it returned results, outside of Informatica.

Any ideas on what the issue could be?

References
Generating a Swagger file
HOW TO: Generate Swagger file in IICS

ravioli
  • 3,749
  • 3
  • 14
  • 28
  • 1
    Hi - have you tried using the Informatica REST connector? https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/rest-v2-connector.html – NickW Feb 09 '23 at 18:08
  • 1
    The REST connector is an option but it can be a bit fiddly according to my experience. If you have CSV as an option and it can be automated I would go with that. – wp78de Feb 10 '23 at 19:08
  • Thanks Nick. This looks exactly like what we want, except it turns out we are using a version of PowerCenter which is not yet in the cloud. – ravioli Feb 10 '23 at 23:18
  • Thanks, but we are trying to avoid CSV because some of our input is coming with special characters which we are trying to use for end-of-line and delimiters. We are hoping to avoid these issues by using JSON. – ravioli Feb 10 '23 at 23:21
  • Hi, not sure what your point is - does the version of the product that you are using not have REST API as a connector type and have you not found the relevant documentation for your product version? – NickW Feb 10 '23 at 23:36
  • We are on version 10.5.2 (on-premise). Where can we check to see if we have the API connector type available? If it's not available in this version, do you know what version it first became available in? FYI, we are not licensed for the Web Consumer Connector. – ravioli Feb 13 '23 at 15:44
  • We are trying to convert a workflow to use the API instead of intermediary CSV files. Apologies for the newbie questions, this is our first attempt. I appreciate your help. – ravioli Feb 13 '23 at 15:55
  • 1) Read the documentation to see what's available 2) Check you license to so see what you are able to use 3) Talk to your Informatica Account Manager – NickW Feb 13 '23 at 16:54
  • Thanks, we were able to make some progress - please see edited post above. Any suggestions on the `invalid URL` issue we're seeing with Informatica's Swagger File generator? We can connect OK to the SurveyCTO API outside of here, so maybe we're not configuring it properly? We tried different permutations of the API Path / Base Path fields. – ravioli Feb 14 '23 at 00:00
  • If you read the documentation for creating a swagger file, for the URL it states “Mandatory. URL consists of the host name and port number. For example: http://localhost:8000”. That’s not what you have in the screenshot – NickW Feb 14 '23 at 00:28
  • I read the documentation. The public API we configured did not require a port number. – ravioli Feb 14 '23 at 00:35
  • The documentation says that the port number is required, so you probably need to find out what the default port number being used by the API is (probably 8000) and try that – NickW Feb 14 '23 at 00:42

0 Answers0