hebervn opened a new issue, #5759:
URL: https://github.com/apache/hop/issues/5759

   ### Apache Hop version?
   
   2.14.0
   
   ### Java version?
   
   24.0.1
   
   ### Operating system
   
   Windows
   
   ### What happened?
   
   Hello everyone.
   
   I am migrating a successful Pentaho Kettle (PDI) 9.4 transformation to 
Apache Hop and encountering an issue with the HTTP Client step when passing 
empty string values as parameters. The pipeline runs perfectly in PDI 9.4 but 
fails in Apache Hop.
   
   Pipeline Setup
   
   <img width="103" height="206" alt="Image" 
src="https://github.com/user-attachments/assets/fc73027d-ed7c-4e2a-be35-37b73d053c0b";
 />
   
   - Data Grid: This step provides the input data.
   --> Field hsApiIntegracao: Has a valid string value.
   -- >Fields nrContrato, nrAno, nmTipoAtoContrato: Are explicitly set as Empty 
String using the "Set empty string? Y" option.
   
   <img width="1062" height="327" alt="Image" 
src="https://github.com/user-attachments/assets/6bc4e448-94ff-42af-b463-9c4ecb6c3608";
 />
   
   - HTTP Client: The step is configured to use the fields as URL parameters 
(GET request)
   
   <img width="1400" height="696" alt="Image" 
src="https://github.com/user-attachments/assets/21f9af41-14ef-4058-b7f2-7b5abe4acb02";
 />
   
   When running the transformation in Apache Hop, the HTTP Client fails with a 
HTTP Status 500 and the following exception returned in the result field:
    ----  System.InvalidOperationException: Missing parameter: nrContrato. -----
   
   <img width="1406" height="727" alt="Image" 
src="https://github.com/user-attachments/assets/d6978597-8321-418e-a63b-9e87834c2bf6";
 />
   
   The log confirms the field is an empty string:
   - nrContrato =
   
   Troubleshooting Steps Already Taken
   - Parameter Configuration Check: The parameters are configured identically 
to the working PDI transformation.
   - Null/Empty Check: Confirmed that the field is an Empty String, not null. 
Used the If Null step as an alternative check, which did not resolve the issue.
   - System Variable: Set the critical system variable to force distinction 
between empty string and null:
   -- > HOP_EMPTY_STRING_DIFFERS_FROM_NULL=Y 
   - Alternative Step: Tried replacing HTTP Client with the REST Client step, 
but without success.
   
   ### Issue Priority
   
   Priority: 3
   
   ### Issue Component
   
   Component: Pipelines


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to