Member since
12-11-2020
5
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
31724 | 12-17-2020 07:21 AM |
12-17-2020
05:58 PM
1 Kudo
@stevenmatisonYou were correct as the other attributes were listed at the bottom of the Attribute Values. I didjn't notice the scroll bar and needed to scroll down. Thanks again.
... View more
12-17-2020
12:38 PM
@stevenmatisonI used your template and tried to assign attributes using EvaluateJSONPath as show here: This is the JSON data entering the EvaluateJSONPath processor. {"user_id":"68","course_id":"HA044","completed_on":"12-15-2020","score":null} However only the "crsID" and "dateCompleted" attributes are showing as attributes in the queue after this processor and I don't understand why.
... View more
12-17-2020
07:21 AM
@stevenmatisonThanks for telling me about the templates. I downloaded these and will use as a guide.
... View more
12-16-2020
09:52 AM
I'm totally new to NiFi and learning as I go, but am against a hard deadline and need urgent assistance. I was tasked to create a data interface between two learning systems to send course completion data. I'm creating a flow to send course completion data from one system to another and have a JSON formatted file (to send as HTTP body to send as a CURL post?) This is the sample JSON data that I've created so far: {"user_id":10042,"username":"de","course_id":"C00230","completed_on":"12-02-2020","SCORE":100} The suggested HTTPS Curl request format is provided below. curl -v -X POST -d "j_username=admin&j_password=admin&userID=MORRW001&crsID=C00565&dateCompleted=2020-11-16&testScore=100&courseType=a" https://lms.dev.test.net/jw/web/json/data/ How do I configure the InvokeHTTP processor to send it correctly? Do I need to reformat the JSON data so it's in the correct format for the curl format shown above? Remember I'm just a NiFi novice, so details, including screenshots would be appreciated. Thanks in advance!
... View more
Labels:
- Labels:
-
Apache NiFi
12-11-2020
08:29 AM
I'm new to NiFi and having an issue with a workflow. I created a MySQL query to pull in training course completions into a JSON RecordSetWriter format. When I view the queue contents, the "completed_on" attribute shows as a string {"name":"completed_on","type":["null","string"]} whereas it needs to be "datetime". The data appears as a string formatted like this. ("completed_on":"1605870000000") How can I convert the attribute back to a date format so I can get the data to read in YYYY-MM-DD format?
... View more
Labels:
- Labels:
-
Apache NiFi