You can not achieve it by DP_GET_STREAM_FROM_URL, due to program run it in background.
But you can fetch the file from FTP.
Create one FTP and define it in SAP and fetch the file and then data from FTP folder.
DATA : is_variant LIKE disvariant.
is_variant-report = sy-repid. is_variant-variant = '/LAYOUT_NAME'. "Layout Name Saved in the Report
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING i_callback_program = sy-repid i_callback_top_of_page = 'TOP_OF...
