question NiFi design to include REST auth in SQL to JSON to HTTP POST in Support Questions

NiFi design to include REST auth in SQL to JSON to HTTP POST

abhai — Sat, 19 Feb 2022 16:07:48 GMT

Hi All.

I'm relatively new to NiFi and would like a little help in designing a data flow that looks like this:

SELECT from a SQL data source
split/convert to JSON
optionally transform JSON
merge to 500 record batches
POST to target via REST API (requires session token from API auth POST)

I know how to create this flow in NiFi. The part I'm having trouble with is including a step that gets a session token via the REST API auth endpoint. I can get the session token using InvokeHTTP no problem. I just don't know how to add the session token to the flow file(s) containing the data to POST to the API.

Thanks for your help.

Re: NiFi design to include REST auth in SQL to JSON to HTTP POST

araujo — Sun, 20 Feb 2022 11:22:26 GMT

Hi, @abhai ,

Please check my response to this question. It may also address yours.

Regards,

André

Re: NiFi design to include REST auth in SQL to JSON to HTTP POST

abhai — Mon, 21 Feb 2022 14:33:56 GMT

Hi @araujo ,

This is exactly what I was looking for. Thanks very much!