請找到一個示例有效負載，我正在嘗試根據更新日期洗掉一個塊。我正在尋找更新日期距當前日期不到一周的訊息塊。
[
{
"firstName": "person1",
"lastName": "lname",
"createdDate": "2021-11-18T03:08:50.000Z",
"externalId": null,
"id": "123",
"updatedDate": "2022-03-18T19:33:28.792Z",
"title": "XXXX",
"email": "[email protected]",
"enabled": true
},
{
"firstName": "P2",
"lastName": "lname2",
"createdDate": "2021-10-26T19:12:16.000Z",
"externalId": null,
"id": "125",
"updatedDate": "2022-03-01T18:01:19.762Z",
"title": ".",
"email": "[email protected]",
"enabled": true
}
]
使用以下代碼獲得所需的結果。remove 陳述句似乎沒有從 中洗掉集合body1，或者我在這里做錯了。嘗試添加body1到訊息正文，不作業。嘗試使用構建器，這給出了一個完全不同的錯誤。任何幫助將不勝感激。
import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap; import groovy.json.*;
import groovy.json.JsonSlurper;
import groovy.json.JsonBuilder
def Message processData(Message message) {
//Body
def body = message.getBody(java.lang.String) as String;
def body1 = new JsonSlurper().parseText(body)
def jsonOp
def builder = new JsonBuilder()
def today = new Date()
def targetDate = today - 7
pastweek = (targetDate.format("yyyy-MM-dd\'T\'HH:mm:ss'Z'"))
body1.collect.eachWithIndex { it,index->
if ( it.updatedDate < pastweek )
{
it.remove(index)
}
else {
builder {
'firstName' it.firstName
'lastName' it.lastName
'email' it.email
'updatedDate' it.updatedDate
'enabled' it.enabled
}
}
}
def finalJson = builder.toPrettyString()
message.setBody(finalJson.toString())
return message;
}
uj5u.com熱心網友回復：
import groovy.json.*
def Message processData(Message message) {
def body = message.getBody(java.lang.String) as String
def data = new JsonSlurper().parseText(body)
def pastweek = (new Date()-7).format("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'")
data.removeAll{it.updatedDate < pastweek}
message.setBody(new JsonBuilder(data).toPrettyString())
return message
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/448556.html
上一篇：使用Jolt的串列轉換串列
下一篇：未捕獲的語法錯誤：控制臺中App.js:18:1處JSON.parse(<anonymous>)位置0處JSON中的意外標記u