Hello,
I am new to the community and to the Generic Extractor, but I have read through the full help article and am still unsure if this is possible or if it could only be done with a transformation after the fact.
I am working with Revel POS API and am currently pulling in product data from the API. I have the extractor working and it pulls in the columns needed, however some data is represented by a new endpoint. I want to grab the result of that endpoint and map one of the fields into the main table. I figure if this is possible, it's with Child Mapping, but that seems to only map to a new table, while I want the data to put placed within the same table.
Am I mssing something in the tutorials on how to do this, or is this not possible?
For example when pulling a product, there is a Category field with values of "/products/ProductCategory/8503/", which can be utilized as a new endpoint to get information on the Category. When pulling that information I get a new object with "name" as one of the available fields to grab. Can I get that "name" field and put that into the Category field instead of the endpoint reference?
Thanks for any help or suggestions
-Chris
Hi Chris, do you mean:
you need to define which item should be taken as a variable for the child job? -> Jobs | Keboola Connection Developers Knowledge Base
or do you need to inject the value from one table into other table? -> this is not possible, you basically need to use the transformation to do so. As I imagine you will model the data anyways its an obvious choice.
Hi Martin,
Thanks for the response. From the help article, it looks like a Child Job is used only to create a second table. I was trying to see if while pulling Products, I could do a second pull from ProductCategory to retrieve the Category Name and put that name into the Product table instead of the end point that it gives from the Product Table.
such as, from product with a child pull from product categories
map id to id, name to name, child>category name to category (all to one table)
Seems like this is not possible, so I will just work on manipulating the data after it's pulled in.
I see, yes, this is not possibly and the transformation afterwards would be the way.