Skip to main content
Solved

RDM import data by API call online service - how to get the id back out in the response?

may_kwok
Star Blazer L3
Forum|alt.badge.img+4

I’m using RDM 14.2 (soon to be upgraded to 14.5) and I need to build an API endpoint to accept incoming data.

I have an integration input and will use an RDM Importer step to import the data into my table.

My table has a generated id as a primary key and I need to provide the generated id as a response back to the incoming API call.

But the RDM Importer step stops there. It doesn’t tell me the id.

 

How do I then get the id back? I could make an RDM Extended Reader step in the plan, but I cannot guarantee the Reader step is executed after the Importer step, because the Importer step doesn’t have an out endpoint, it only has an err endpoint. And if I query the data before the insert is committed then I will end up with nothing to provide.

 

Any ideas?

 

(I believe the new RDM REST API functionality is read only so that won’t be relevant here?)

Best answer by BrianF

Hi May,

I did similar recently, triggering an external notification after the importer step.

I did that by adding a Random Record Generator step, with an INTEGER “Number from Sequence” column called “lineNo” and a STRING shadow column called “Error”, defaulted to null.

I then did a Union Same to the output from the RDM Importer step which can then force processes to run after that. 

I need to refine it, probably with a Condition step, to check if there really is an error, but it works for now.

Hope that helps!

Brian.

View original

BrianF
Ataccamer
Forum|alt.badge.img+3
  • BrianFAtaccamer
  • Ataccamer
  • January 15, 2024

Hi May,

I did similar recently, triggering an external notification after the importer step.

I did that by adding a Random Record Generator step, with an INTEGER “Number from Sequence” column called “lineNo” and a STRING shadow column called “Error”, defaulted to null.

I then did a Union Same to the output from the RDM Importer step which can then force processes to run after that. 

I need to refine it, probably with a Condition step, to check if there really is an error, but it works for now.

Hope that helps!

Brian.

may_kwok
Star Blazer L3
Forum|alt.badge.img+4
  • may_kwokStar Blazer L3
  • Star Blazer L3
  • January 15, 2024

💡 Thanks Brian! I’ll give that a go!

Reply


Community Terms of Use & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings