Forum Discussion

AAB's avatar
AAB
Regular Contributor
6 years ago

Error message "The column path must start with a row path expression"

Hi everyone,   For my comparison testcase I need to compare the results of 2 different files with each other. For the POC I'm using mock data in files. One is an excel file the other is a json fi...
  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    6 years ago

    AAB,

     

    I've managed to get the cbe_number and denominations values with the following settings:

     

    Does it suit you?

     

    The expression in the Row Path field is the beginning of the full expression. It's common for properties.

    The expression in the Column Paths is the end of the expression.

     

    So, the full expressions will look like:

    $['cbe_number'] - for the cbe_number property

    and

    $['denominations'][0]['value'] - for the denomination property

AAB's avatar
AAB
Regular Contributor

Yaks! So sorry people! I've send the wrong file...  :-(  I'm so into different tickets and my job for the moment that I've missed.

Nastya_Khovrina  and richie the project and the files to read out and to stash are added.

So the "Results Comparison.xlsx" should have the results of the 2 environments (2 Testcases) whereas I can compare the responses in the same sheet.

richie I remember now why I used a Groovy Script to read out the json file. If you add a DataSource object and you select JSON one is obliged to already have a response before you can use the "pick and select". But as I don't get responses for the moment, I wanted to mock this.  ;-) 

 

Please let me know if I can be of any other help.

 

Thanks in advance,

Kind Regards,

AboveAndBeyond

 

 

Nastya_Khovrina's avatar
Nastya_Khovrina
SmartBear Alumni (Retired)
6 years ago

AAB,

 

I've managed to get the cbe_number and denominations values with the following settings:

 

Does it suit you?

 

The expression in the Row Path field is the beginning of the full expression. It's common for properties.

The expression in the Column Paths is the end of the expression.

 

So, the full expressions will look like:

$['cbe_number'] - for the cbe_number property

and

$['denominations'][0]['value'] - for the denomination property

  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    SmartBear Alumni (Retired)
    6 years ago

    I'm glad to hear that the provided solution helped!

     

    By the expression, I meant the JSONPath expression, you can read more about it here: https://goessner.net/articles/JsonPath/

     

    In ReadyAPI, the full JSONPath expression is evaluated as:

    Row Path + Column Path

     

    BTW, there are some online validators: 

    - http://jsonpath.com/

    - https://jsonpath.curiousconcept.com/

     

    Also, there is an example in our documentation which shows how you can work with the JSON DataSource: 

    https://support.smartbear.com/readyapi/docs/testing/data-driven/types/json.html

     

    I hope this helps.

  • AAB's avatar
    AAB
    Regular Contributor
    6 years ago

    Nastya_Khovrina 

    Thanks a lot! It works as a sharm  :-)

     

    But one more question please:

    "

    The expression in the Row Path field is the beginning of the full expression. It's common for properties.

    The expression in the Column Paths is the end of the expression."

     

    what do you mean with " of the expression" please?  Is this the beginning of the json file? the begin node?

    "The Column Path is the end of expression" of the node from where it's reading? I'm a noob in json  :-(

    Thanks in advance

    Kind Regards,

    AboveAndBeyond.