PxPlus User Forum

Twitter Twitter Twitter

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - michaelgreer

Pages: [1] 2 3 ... 7
1
Programming / Re: Error 13 on [tcp] connection with secure
« on: August 03, 2022, 03:08:38 PM »
Mike and Devon,

Thanks for your assistance and patience.  I am running windows where the issues are occurring. I did install the latest version of PxPlus and it had no issues.  I also do not find SSL installed on my machine.

Connected to the customer who is redhat, running pvx 12.50.  *No* issues, so this is done I guess.

Never mind on this --->  Seeing invalid key so staring in demo mode. One question. I have a PVXKEY set for all of my PxPlus instances.  When I launch the 2022 pxplus I expected to have an issue with that but it came up in Demo mode. How is it "ignoring" my PVXKEY env. variable?

2
Programming / Re: Error 13 on [tcp] connection with secure
« on: August 02, 2022, 04:21:46 PM »
I currently have access to systems up through 1510.  I always get:

Unable to connect securely (err/ret=0/0)

I tried adding ";TLS1.2" after secure, but same thing (this was at 1510).


3
Programming / Re: Error 13 on [tcp] connection with secure
« on: August 02, 2022, 10:56:28 AM »
Devon,
I tried this open: api.anvyl.com;443;secure;TLS1.1
Still got my error 13.  My version doesn't support TLS1.2.

Mike, I did not have a cert bundle but downloaded the one you referenced and put it in my pvx base directory. Still a no go.

Thoughts?
Michael

4
Programming / Error 13 on [tcp] connection with secure
« on: July 29, 2022, 11:27:43 AM »
This is version 15.1.  When I attempt to use request the open on a website using ";secure" and port 443 I get an error 13. I can use postman and disable all but TLS 1.1 and I have no issue.  Thoughts on how I might get the open.

5
Language / Re: Json element class
« on: July 12, 2022, 11:57:53 AM »
This will work. Thanks.  I had considered it but couldn't find the exact syntax described.  ::)

6
Language / Json element class
« on: July 12, 2022, 10:39:31 AM »
I am looping through a PO to build a json like this
po$["po.order_items.1.item"]="widget1"
po$["po.order_items.1.price"]="10.25"
po$["po.order_items.1.qty"]="2"

There could be anywhere between 1 and several hundred elements in the items array.  Oddly, I need to output price as a numeric ( but not quantity). Is there a way to do this without have to specify *every* price element in the "with num()" phrase?

7
Programming / Re: Loading a json pre version 11
« on: July 02, 2022, 08:15:47 AM »
Mike, it would it need be simpler were not Infor in the mix.  I think the federal government takes lessons in arcane bureaucracy from them  :).

8
Programming / Loading a json pre version 11
« on: July 01, 2022, 02:39:07 PM »
All,  I developed a routine to retrieve JSON data from an API and, developing at 11.5, used the dim load array$[all]=json$.  My customer is running at 9.x and this feature is not available. Does anyone have a routine to load or parse a json.  I have parsing ability, but it isn't foolproof.

9
Registration and Setup / Re: Linux Licensing
« on: June 21, 2022, 06:51:15 PM »
Thank you.  I figured if Windows could do it so could linux but I didn't thing the -bkg did anything in linux.

10
Registration and Setup / Linux Licensing
« on: June 21, 2022, 12:39:23 PM »
I need to run a "stand alone" application that, unfortunately, needs to have PVX running on a Linux box and accessed via Windx.  Can this be accomplished with a single user license.  I'm afraid the simple client server instance will use a license and then the Windx connection will use one. Is this correct or can I get by with one license?

11
Web Services / Re: Setup EZWeb server and API calls
« on: June 02, 2022, 12:22:40 PM »
If I am reading your question correctly, you do not need EZ Web at all. Your pxplus pro will include *plus/web/request.  This will easily allow you to send in a url and a payload (for a post endpoint).  You can hit both REST and SOAP endpoints and receive the responses.

12
Language / Re: Json Element addressing
« on: May 24, 2022, 10:56:45 AM »
Stephan,

Except for having to add a "." after the first record #, this is perfect. Thanks!  Thought I had tried that, but missed an index.

Michael

13
Language / Json Element addressing
« on: May 24, 2022, 10:16:30 AM »
I have this JSON:
{
  "totalSize":1,
  "done":true,
  "records":[
    {
      "attributes":{
        "type":"Order",
        "url":"/services/data/v54.0/sobjects/Order/8012D0000016xq5QAA"
      },
      "Id":"8012D0000016xq5QAA",
      "OrderNumber":"00000100",
      "CreatedDate":"2022-02-21T13:13:01.000+0000",
      "OrderItems":{
        "totalSize":1,
        "done":true,
        "records":[
          {
            "attributes":{
              "type":"OrderItem",
              "url":"/services/data/v54.0/sobjects/OrderItem/8022D000001GgV5QAK"
            },
            "Id":"8022D000001GgV5QAK",
            "Product2":{
              "attributes":{
                "type":"Product2",
                "url":"/services/data/v54.0/sobjects/Product2/01t2D0000050iKrQAI"
              },
              "StockKeepingUnit":"25"
            },
            "Quantity":5.0,
            "TotalPrice":1250.0
          }
        ]
      }
    }
  ]
}

I cannot figure out how to address, the OrderItems, or the "records" under that element.  The above is the result of a dim load test$=myjson$.

14
Programming / Re: Need leading zeros in excel
« on: May 06, 2022, 09:41:32 AM »
When using excel UI if you put an apostrophe (hex 27) you get leading 0s displayed with no apostrophe. I have successfully added that to my output to get the desired effect in some cases. Other instances it fails, but it is worth a try.

15
Programming / Re: UCS-2
« on: May 06, 2022, 09:25:53 AM »
Thanks Mike. It is not clear to me using the cvs function how I specify 16 bit UTF-8.

Pages: [1] 2 3 ... 7