우선 동영상 참조해서 시작함.
https://www.youtube.com/watch?v=3FNWtmtHOE4
https://www.youtube.com/watch?v=N4K8Sa4uHUk
기본적으로 바로 Rest client 로 사용하면 안되는것같다.
동영상을 참조해서 와꾸 짜고,
변수는 자바스크립트로 해결
http://rpbouman.blogspot.com/2009/11/pentaho-data-integration-javascript.html
Pentaho Data Integration: Javascript Step Performance
I just read a post from Vincent Teyssier on cleaning strings using the javascript capabilities of Pentaho Data Integration (also known as...
rpbouman.blogspot.com
자바스크립트는 많이 테스트해보아야함.
json input으로 받아온후, 데이터 조율은 동영상에도 나오지만 Xpath 로 하는 것 같음. 아래 두개로 해결함.
https://goessner.net/articles/JsonPath/index.html#e2
JSONPath - XPath for JSON
A frequently emphasized advantage of XML is the availability of plenty tools to analyse, transform and selectively extract data out of XML documents. XPath is one of these powerful tools. It's time to wonder, if there is a need for something like XPath4JSO
goessner.net
JSONPath Online Evaluator
JSONPath Online Evaluator
jsonpath.com
--------------------------------------------------------------------------------------------------------------------------
참조 스택오버플로우
How to change dynamically value field of "Generate rows step" in Pentaho data integration, to be used to get data from A rest AP
I want to access data from a rest API using pentaho data integration and save the result into a table. I am using the following steps: Generate rows step Rest Client JSON input select values Table
stackoverflow.com
댓글