i-doit API Connection

Anonymous — Tue, 25 Jul 2017 13:22:38 GMT

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

Re: i-doit API Connection

Anonymous — Tue, 25 Jul 2017 13:56:16 GMT

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-in-talend

topic Re: i-doit API Connection in Talend Studio

i-doit API Connection

Re: i-doit API Connection