How to parse an Employee Central ODATA into ABAP table

[kmoore007]

I can retrieve a SuccessFactors Employee Central ODATA file, for example ODATA BenefitEnrollment, using an ABAP program.  But I'm unsure about how to parse the data into an internal table with the retrieved data columns and values.  Does someone have an example ABAP program on how to achieve this?

Thanks,

Kenneth

[kmoore007]

Sampe code below, but I'm not sure how to get the Odata into a table listing the fields and values:

lv_uri = |/odata/v2/BenefitEnrollment?&$filter=id eq '90000001_DENT'&fromDate=1800-01-01&toDate=9999-12-31|. 

    cl_http_utility=>set_request_uri( request = go_http_client->request
                                      uri = lv_uri ).

go_http_client->send( EXCEPTIONS http_communication_failure = 1 http_invalid_state = 2 ).

go_http_client->receive( EXCEPTIONS http_communication_failure = 1 http_invalid_state = 2 http_processing_failed = 3 ).

CLEAR lv_cdata.

lv_cdata = go_http_client->response->get_cdata( ).

CLEAR lv_xdata.

CALL FUNCTION 'SCMS_STRING_TO_XSTRING' EXPORTING text = lv_cdata IMPORTING buffer = lv_xdata EXCEPTIONS failed = 1 OTHERS = 2.

CHECK sy-subrc = 0 .

CLEAR: lt_xml, gt_ret2.

CALL FUNCTION 'SMUM_XML_PARSE' EXPORTING xml_input = lv_xdata TABLES xml_table = lt_xml return = gt_ret2.

REFRESH gt_xml.

APPEND LINES OF lt_xml TO gt_xml.

[kmoore007]

I found a demo program on how to parse XML, DEMO_SXML_TOKEN_READER. I believe I can use this as an example to get what I need.

[turkaj]

Hi Kenneth,

that depends on the format in which you receive the data. If you receive it as a JSON file, then you can simply convert it into an ABAP structure using the following method.

DATA lv_odata_json TYPE string. "your ODATA-JSON-String
DATA lt_abap_data TYPE ref to data. "here you can create a corresponding ABAP structure/table and use it here

TRY.
    /ui2/cl_json=>deserialize(
                    EXPORTING
                      json             = lv_odata_json
                    CHANGING
                      data             = lt_abap_data ).
CATCH cx_sy_move_cast_error.
    "Error handling
ENDTRY.

It is also possible to create a dynamic structure, but it is better if you create a corresponding ABAP structure in ABAP and then transfer the string to your ABAP structure using the method mentioned above.

Regards
Jim

[junwu]

if the data is in xml format, you can use xslt

[kmoore007]

I can retrieve the data in string or json format. I can convert from string to XML using a couple of functions.