Informatica PowerCenter语言 - [ERROR] HTTP调用程序在调用HTTP时遇到错误

Question

我需要向HTTP转换发送一个JSON，它将发送到Azure搜索。

我有以下问题:

Message Code: PCHTTP_33016
Message: [ERROR] HTTP Invoker encountered an error while invoking the HTTP. Reason: {"error":{"code":"","message":"The request is invalid. Details: parameters : Invalid JSON. Unexpected end of input reached while processing a JSON string value.rn"}}

我正在尝试发送以下JSON:

{"values": {"_Load_Timestamp": "2021-10-12 15:30:13.878228","_Load_RunId": "1","NUM_ORDI": "XXXXX450","TIP_MOVI": "X","COD_XXX": "XXX","NUM_XXX": "XXXXXXX4031","TIP_DOCU": "1","NUM_DOCT": "0","NUM_DOCD": "0","MOV_DTEF": "9999-12-31 23:59:59.000000","MOV_DTSC": null,"MOV_DTEM": "9999-12-31 23:59:59.000000","MOV_DTRG": "9999-12-31 23:59:59.000000","COD_TMOV": "1","COD_CAUS": "0","MES_LIMI": null,"DAT_ULCO": null,"NUM_ORDX": null,"NUM_MOVX": null,"TIP_RELA": null,"COD_PRVZ": "24","COD_USER": "XXXXX","DES_NOTE": null,"COD_STAT": "0","PRG_STAM": null,"SEQ_TITO": null,"FLG_AQTZ": null,"COD_GEST": null,"COD_USE1": null,"MOV_DTIT": null,"FLG_EMTI": null,"MOV_RETT": null,"FLG_VERI": "N","FLG_STMP": "N","TIP_POLI": "P","CAU_BLOC": null,"NOT_BLOC": null,"STA_AUTO": null,"IDN_AUTO": null,"PTN_AUTO": null,"DAT_INGA": "9999-12-31 23:59:59.000000","DAT_INCO": null,"WEB_COMP": "XXX","FNO_ANIA": null,"IDE_NAPC": null,"COD_CAPA": null,"DAT_PEDG": null,"DAT_OPER": null,"NUM_STMP": null,"FLG_BOZZ": null,"FLG_P021": null,"VAL_SPPO": null,"NUM_SPPO": null,"_UPDATE_DATE": "2021-10-12 12:51:13.878233","_CAPXACTION": "I"}}

我还在在线json验证器中检查了json，语法是有效的。(jsonlint)

我该如何解决这个问题?

Answer 1

是否尝试删除空值?

{
"values": {
"_Load_Timestamp": "2021-10-12 15:30:13.878228",
"_Load_RunId": "1",
"NUM_ORDI": "XXXXX450",
"TIP_MOVI": "X",
"COD_XXX": "XXX",
"NUM_XXX": "XXXXXXX4031",
"TIP_DOCU": "1",
"NUM_DOCT": "0",
"NUM_DOCD": "0",
"MOV_DTEF": "9999-12-31 23:59:59.000000",
"MOV_DTEM": "9999-12-31 23:59:59.000000",
"MOV_DTRG": "9999-12-31 23:59:59.000000",
"COD_TMOV": "1",
"COD_CAUS": "0",
"COD_PRVZ": "24",
"COD_USER": "XXXXX",
"COD_STAT": "0",
"FLG_VERI": "N",
"FLG_STMP": "N",
"TIP_POLI": "P",
"DAT_INGA": "9999-12-31 23:59:59.000000",
"WEB_COMP": "XXX",
"_UPDATE_DATE": "2021-10-12 12:51:13.878233",
"_CAPXACTION": "I"
}
}