Rest API Connector

[zohebakber]

Hi Team,

I am trying to import data from Rest API URL.
I tried to see the documentation regarding the JDBC connector. But, the url throws an error wile testing.

Can somebody suggest anything on the same.

My Rest API URL: https://dsav2.dataweave.com/app/shareofsearch/score/?filters={%22pivot_by%22:[%22sourc[…]%20%22m2023...

[Ravid_PaldiTeam]

Hi @zohebakber ,

Can you elaborate more on what you are tryign to do with the API and why you wish to use a custom JDBC connector? 

I'm asking because developing a custom JDBC connector is kinda using the "heavy guns" approch and would be relevent only for VERY specific use cases.

Most odds are that you have a much simpler approach that you can take. 

Feel free to reach out directly. We're always happy to assist (: 

Cheers,
Ravid

[email protected] 

Paldi Solutions

BTW, the request you've provided works for me with a response when I ping it (I assume you're utlizing the WAT in your server? ) :

[zohebakber]

Hi Ravid,

Thanks for the quick response.

There is no specific need to create a custom JDBC connector. All I want is, to take data from the above mentioned API.

[Ravid_PaldiTeam]

Yes. But what exactly do you want to do with the data. 

Here are soem guiding quetions:
1) Where from you want to exprot the data?

2) Where you want the exported data to be kept?

3) Is there any processing of the data that you need to be done in the middle? 

4) What is the frequncy / data freshness that you wish to maintain? 

Cheers,

Ravid

[GuyRaz]

Hi @zohebakber ,

If you are familiar with Python and wish to add data to ElasticCube so it can be explored in dashboards, then the best option is to use Sisense Custom Code Transformation as part of the build process -  https://docs.sisense.com/main/SisenseLinux/transforming-data-with-custom-code.htm