i-doit API Connection

Highlighted
One Star

i-doit API Connection

Hello there,

i have a newbie question and i just don't see how to do it.

 

I need to import a csv into i-doit CDMB and want to use the REST API.
So i tried to use tRestClient to connect with the API and upload my csv line by line but i don't get the necessary json right:

 

Example JSON for Body

 

{
    "jsonrpc": "2.0",
    "method": "cmdb.object.create",
    "params": {
        "type": "C__OBJTYPE__SERVER",
        "title": "My little server",
        "apikey": "c1ia5q"
    },
    "id": 1
}

What i need is a way to send this per tRestClient and use a colume from my csv for TITLE (and some other fields).

 

I tried it with tRest where you can set this as body with no problems, but, call me stupid, i don't get around how to get this done with a variable from my csv.

 

I would be delighted it someone can help me with some ideas

 

Kind regards,

Rene

Employee

Re: i-doit API Connection

Hi 

You will build the JSON using tXMLMap and other components.  Read this https://stackoverflow.com/questions/30803355/send-json-request-using-trestclient-with-nested-object-...

 

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download