scottklement.com

I'll repeat my earlier request ... show us some code. There are such things as (pseudo) variable length records that can be used in COBOL - but I don't know if that is what you are using without seeing your code. Also, why are you not simply using CPYFRMIMPF to split the CSV into its component field...

Scott, I was thinking last night that there was not really anything that DATA-INTO could do - so I agree an IDEA is not an option. Agreed that changing YAJLINTO would also add complexity to the learning process. JSON is "better" than XML in part due to its flexibility and simpler rules - b...

Kinda difficult to know what might be wrong without you having posted the File specifications and record layouts etc.

I wonder Scott if this isn't worthy of an IDEA for DATA-INTO? Or is it something that possibly could be added to YAJLINTO to supply a "made-up" name to RPG when encountering such an element? RPG does support effectively support multi-dimensional arrays but the inner elements need a group n...

In case you are stuck I found time to play and see if my understanding was correct. Here's my version which handles your noname array just fine. RPG fills in the element count in the PSDS with the number of DS array entries, Similalrly I used countprefix to name the count for the inner array. This w...

Off the top of my head this would simply require targeting a DS array with DATA-INTO. I think the RPG will accept any name at the top level but since I’m just doing this on my phone I can’t look it up. Also if that doesn’t work I’m pretty sure YAJLINTO provides a way to name the root ele,ent. It is ...

Not familiar with Sharepoint but it appears to offer REST services which could be used to upload such files. You could invoke them from RPG for example by using IBM's IWS or my preferrred option which is Scott's HTTPAPI. You may also be able to do it by using the new SQL capabilities buty I'm not fa...

You use the http_xproc API with the first parameter of HTTP_POINT_ADDL_HEADER to specify your custom routine to be called and then build the required header content in that procedure. Here's how I use it with Zoom APIs - this call has to occur before you invoke the http_string or whatever of the htt...

There may be other issues but in the call to HTTP_POINT_ADDL_HEADER you are not just adding additional headers, you are including base ones like Host: and Content-Type that HTTPAPI is already adding. If you check the debug log you can confirm this.

Some of your code would help. For example of the call sequence and the definitions of the relevant fields. An extract of the relevant portion of the json would;d be useful too.