Hi,
I recently started working with Fabric APIs and I am playing around with a script to automate the creation of resources and the ingestion of data from an IoT Hub source into a kusto table. I was able to easely create the items using a powershell script, but I’m having a hard time finding documentation on how to associate an ingestion mapping with an Eventstream.
In the UI, I can navigate to a table, select Get Data, and configure the Eventstream, where I have the option to choose an existing ingestion mapping and apply it, however, I haven’t been able to find anything on how to automate this process via the API.
My goal is to ingest the entire message coming from the IoT Hub into a single column in the table, as a json string. The mapping I use in the UI looks like this:
.create-or-alter table <table_name> ingestion json mapping "<mapping_name>" '[{ "column": "<column_name>", "path": "$", "datatype": "string" }]';
On the official documentation I saw a few mentions of parameters like "ingestionMappingReference" and "mappingRuleName", but no example of them being used in the API context. Even the examples from GitHub lack those parameters, but given that they are mentioned I suppose there has to be a way of automating this, otherwise it seems like a major flaw.
Any suggestion would help, either if there is an Eventstream configuration parameter to set or a different API call I can use after creating the Eventstream. Anything helps 🙂
