Forum Discussion

adityamohanty's avatar
adityamohanty
New Contributor II
3 years ago
Solved

How to rename a column in a single expression without impacting the other columns in a json file

My source data looks like this. I want to rename "Emp.Type" column to "EmpType" in a single expression without impacting the other columns in json file. I don't want to use column map in mapper where...
  • Supratim's avatar
    Supratim
    5 years ago

    @Raph Just to validate, run your pipeline, once it’s completed check the no of document from output view of Soap execute snap from runtime log. If no of document count is 1 , which means you got a response from server, if any error comes either pipeline throw error or it will go to error view.

    You click on user setting whether auto validation is checked or not, to get the response during pipeline validation time.

koryknick's avatar
koryknick
Employee
3 years ago
Copy LinkReport

Can you show the properties of your Sort snap? A sample of the incoming documents to the Sort would also be helpful.

rmedeiros's avatar
rmedeiros
New Contributor III
3 years ago
Copy LinkReport

These are the incoming docs:

This is the sort snap:

This is what happens when i try the same query but async:

  • acesario's avatar
    acesario
    Contributor II
    5 years ago
    Copy Link

    Output meaning error?
    For this you need to add an error output to your soap execute (see screenshot below.

    Also helpful might be to see what you are writing or the response.
    Here is a link to the original conversation:Questions a soap execute Template - #10 by acesario

    I just ran into the same thing with seeing what I was sending to the soap execute. I was directed to use an xml generator, as shown here where i’m using a copy to send the input to both the soap execute and to the xml generator. The key here is copying your template to the edit xml input in the generator

    • Raph's avatar
      Raph
      New Contributor II
      5 years ago
      Copy Link

      Output meaning it is a GET method. So after input of a person ID in the mapper snap there is no preview or output of the SOAP execute snap.

      I do not believe I need an XML generator to input one “string”. If I am mistaken please let me know.

      I believe our questions are not related.

      • acesario's avatar
        acesario
        Contributor II
        5 years ago
        Copy Link

        @Raph Correct,you dont need the xml generator to submit… it is only to ‘see’ what you are sending in.

        Two ideas:

        1. Add an error output to the soap execute
        2. are you validating? Is the snap step setup for validate and execute?