How to populate item column values from custom input trigger

[jeromeskiply]

Hi there ,
I’m building an IoT App, and I’m using a custom input trigger. Each time that a device send data, we should create a new item (service requests).
My custom input trigger looks like this:

And works well (tested with postman, 200 received, )
Subscribe / unsubscribe is OK.
I’m trying to create an new item based on the output fields of this custom trigger. And I failed…

First try: with the action "Create an Item"
I tried with a Item Column Values field, but I don’t know which format is required. I tried this:

I receive a 200, but nothing happens.
Action trigger looks like this:

Is there a doc somewhere to know the format of itemColumnValues?

Second try: with the action "Create an Item with mapping"
Looks really promising (at least the title), but then, I’m lost:

Same question: is there a doc somewhere or codes example?

[basdebruin]

Hi @jeromeskiply

Did you sign the request you send to the action part? It needs to be signed with your signing secret, something like this: (I store my signing secret in an envVars object)

//Build the post header and body
postHeader = { Authorization: envVars.signingSecret };
postBody = {
trigger: {
outputFields: {
boardId: event.boardId,
itemId: event.pulseId,
},
},
};

//Build the request
const actionRequest = {
url: subscriptionUrl,
headers: postHeader,
body: JSON.stringify(postBody),
};

//Post the request
request.post(actionRequest, function (error, response) {
if (error) throw new Error(error);
});

Hope that make sense.

[jeromeskiply]

Hi @basdebruin,
Yes I did, and I don’t have any auth trouble. I tested it with another action trigger (create item in group) and it works well.
What I need is the doc of the create item and create item with mapping action triggers.

[basdebruin]

Hi @jeromeskiply

Looks like I misunderstood your question. I did not had the need to create an item from the action part yet. I would guess itemValues needs to be formatted as a JSON and within it for each column a value as JSON?

[jeromeskiply]

Yes, probably, I will do some tests. But for the name (see my screenshot), it doesn’t work, and name is an important one.
It would be much easier with a doc

[basdebruin]

To me documentation is the most important missing piece of all API, automations, triggers, apps etc. Certainly room for improvement here

[jeromeskiply]

@dipro @Ben @AlexSavchuk do you know if this documentation exists somewhere? How are you dealing with that internally?

[lalondesteve]

I’m investigating the same thing and didn’t really succeed yet.
I stumbled upon this page, maybe it’ll lead you further than me :

monday Apps - Dynamic Mapping

[jeromeskiply]

Thanks @lalondesteve, I think this is probably where the solution stands. I will let you know if I manage to succeed.

[jeromeskiply]

Solved! Thanks @lalondesteve I missed this page, and this was exactly what I needed.
If you need help for your implementation, please ask.
Cheers,

[basdebruin]

hi @jeromeskiply

I am curious how you used the dynamic field mapping. I intend to use it for two custom fields that are dependent (CF2 is depending on input form CF1) and have troubles configuring this. When I set CF2 to type “Dynamic mapping” it shows up up the recipe configuration with input field setting for “Source entity” and "Dependency. I got the Dependency dropdown filled, but still having trouble what I need to do to populate the Source Entity dropdown.

[jeromeskiply]

@basdebruin I’m using it exactly the way of “Part 2” in the doc.
I created a custom field with key smilioDevice. I’m using a server side definition for the mapping.
Each time that a device send a message, I’m including the custom field key, with the fields included in the mapping.
And this creates the new item with the mapped data.
If you want, I can show my screens, but basically this is very similar to the doc.
And it is very convenient, I love it.

[AlexSavchuk]

Hey @jeromeskiply, @basdebruin and @lalondesteve

Sorry I’m late to the help party here! I’m so excited to see our users help each other though, it’s literally breath-taking.

Thank you for creating the thread and fostering a healthy discussion I’m glad that @lalondesteve was able to point you in the right direction here. Moreover, I’m glad to hear you’re enjoying the way we’ve set this up so far @jeromeskiply

To be transparent with you, I’ve discussed our docs in more detail with Dipro and we both came to the conclusion that it is crucial to make some improvements there. If it wouldn’t be asking for too much, we would really appreciate your input into the specifics of how things are laid out right now, and any adjustments and improvements you would suggest from your point of view as a user. If you could shoot me a PM on the forums here, I’d love to continue the discussion from there to make our documentation easier to digest and navigate.

-Alex

[jeromeskiply]

Ok @AlexSavchuk let’s do this.

[basdebruin]

hi @AlexSavchuk

In general the documentation can certainly use a good refresh. Over the last months I was able to use a lot of features after numerous efforts and in some case using browser dev tools to see what is going on.

For this specific one I do see example of inbound and outbound mapping, but no example how to create a dependency between two custom fields in an integration (monday <> monday) scenario.