Start a new topic

API using json as source

Hi, 

I am trying to use a wsdl metadata shaped like a json and my sources are tables from my oracle database. I tried by mapping each column on its corresponding value or using CLOB data haped as a json mapped on invites or using my column as values except for product where I used a CLOB shaped as a json. None of them worked. The mapping is executed without error for all of them but the invites failed.


Also, the best scenario for us would be to send only once the channel and system's values and have all our invites' values .


image



I am not using the HTTP REST API because I can't select a template even though I imported one. If someone knows how to resolve this issue ?


image


image


Hi Claire !

On your mapping with HTTP Rest API, did you placed a rdbms source ?I don't see input arrow on the capture in your last message.

Without any input rdbms source, you won't be able to select a template.

Hello,


For your first message, it seems the first node of your API isn't linked and I think the API isn't called in this case .


image

 

Could you try to map this first node ?


About your second message, Romain gives you a clue.

It can also be from custom template, a good test can be to isolate these custom templates in an other project, close it, and check if you are able to see the template in your mapping.

Login to post a comment