TypeCast error is thrown when the spreadsheet is not initialised correctly

[sahanHe]

Description:

Let's assume a code segment to read a row from a google sheets using getByKey method.

Workspace|error workspaceError = rainierClient->/workspaces/[1].get();

when the code is executed inside for spreadsheet which is not initialised correctly (number of headers is not equal to the number of fields in entity), we get the following type cast error.

error: {ballerina}TypeCastError {"message":"incompatible types: 'error' cannot be cast to '(test:WorkspaceWithRelations|persist:Error)'"}
        at sahan.test.0.Client:$get$workspaces$^(persist_client.bal:264)
           sahan.test.0:checkWorkspace(main.bal:171)
           sahan.test.0:main(main.bal:349)

Affected Versions:
persist-1.0.0

Suggested Labels (optional):

Suggested Assignees (optional):

[github-actions]

This issue is NOT closed with a proper Reason/ label. Make sure to add proper reason label before closing. Please add or leave a comment with the proper reason label now.

      - Reason/EngineeringMistake - The issue occurred due to a mistake made in the past.
      - Reason/Regression - The issue has introduced a regression.
      - Reason/MultipleComponentInteraction - Issue occured due to interactions in multiple components.
      - Reason/Complex - Issue occurred due to complex scenario.
      - Reason/Invalid - Issue is invalid.
      - Reason/Other - None of the above cases.