Iteration Help through JSON Response

Question 1

Pregunta

Scott Roth · 1 jul, 2025

#JSON #ObjectScript #API REST #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS

I have built a REST operation to submit a JSON Request Body, and in the JSON Response Object, I need to pull out certain values like pureID, portalURL, and under the identifiers array the ClassifiedID that has a term."en_US" = "Scopus Author ID"

{
    "count": 1,
    "pageInformation": {
        "offset": 0,
        "size": 10
    },
    "items": [
        {
            "pureId": 0000000000000,
            "uuid": "xxxxxxxxxxxxxxxxxxxxx",
            "createdBy": "root",
            "createdDate": "2024-11-18T22:01:07.853Z",
            "modifiedBy": "root",
            "modifiedDate": "2025-06-25T13:26:38.733Z",
            "portalUrl": "https://xxxxxxxxxxxxxxxxxxxxx/en/persons/xxxxxxxxxx",
            "prettyUrlIdentifiers": [
                "samiksha-tarun"
            ],
            "version": "506af93393c24eeb70826afa0dd0ed473f1b61cc",
            "name": {
                "firstName": "xxxxxxxxxx",
                "lastName": "xxxxxxx"
            },
            "staffOrganizationAssociations": [
                {
                    "typeDiscriminator": "StaffOrganizationAssociation",
                    "pureId": 1540250714,
                    "employmentType": {
                        "uri": "/dk/atira/pure/person/employmenttypes/academic",
                        "term": {
                            "en_US": "Academic"
                        }
                    },
                    "organization": {
                        "systemName": "Organization",
                        "uuid": "def8fdb5-6206-4bb7-99d6-b1efe8c60939"
                    },
                    "period": {
                        "startDate": "xxxx-xx-xx"
                    },
                    "primaryAssociation": false,
                    "contractType": {
                        "uri": "/dk/atira/pure/person/personcontracttype/openended",
                        "term": {
                            "en_US": "Open ended"
                        }
                    },
                    "staffType": {
                        "uri": "/dk/atira/pure/person/personstafftype/academic",
                        "term": {
                            "en_US": "Academic"
                        }
                    }
                }
            ],
            "selectedForProfileRefinementService": true,
            "gender": {
                "uri": "/dk/atira/pure/person/gender/unknown",
                "term": {
                    "en_US": "Unknown"
                }
            },
            "titles": [
                {
                    "pureId": 1540250717,
                    "value": {
                        "en_US": "Assistant Professor"
                    },
                    "type": {
                        "uri": "/dk/atira/pure/person/titles/designation",
                        "term": {
                            "en_US": "Designation"
                        }
                    }
                }
            ],
            "visibility": {
                "key": "FREE",
                "description": {
                    "en_US": "Public - No restriction"
                }
            },
            "identifiers": [
                {
                    "typeDiscriminator": "PrimaryId",
                    "idSource": "synchronisedPerson",
                    "value": "xxxxxxxx"
                },
                {
                    "typeDiscriminator": "ClassifiedId",
                    "pureId": xxxxxxxxx,
                    "id": "xxxxxxxx",
                    "type": {
                        "uri": "/dk/atira/pure/person/personsources/employee",
                        "term": {
                            "en_US": "Employee ID"
                        }
                    }
                },
                {
                    "typeDiscriminator": "ClassifiedId",
                    "pureId": xxxxxxxx,
                    "id": "xxxxxxxx",
                    "type": {
                        "uri": "/dk/atira/pure/person/personsources/scopusauthor",
                        "term": {
                            "en_US": "Scopus Author ID"
                        }
                    }
                }
            ],
            "customDefinedFields": {},
            "systemName": "Person"
        }
    ]
  }

My REST Operation looks like...

Method PostSearchPerson(pRequest As osuwmc.COM.Request.SearchPerson, Output pResponse As osuwmc.COM.Response.StringResponse) As %Status
{
  #dim tSC As %Status = $$$OK
  try{
  set tHTTPRequest = ##class(%Net.HttpRequest).%New()
  set tHTTPRequest.SSLConfiguration = ..Adapter.SSLConfig
  set tHTTPRequest.Https = 1
  set tHTTPRequest.WriteRawMode = 1
  set tHTTPRequest.Port = ..Adapter.HTTPPort
  do tHTTPRequest.SetHeader("Host", ..Adapter.HTTPServer)
  Do tHTTPRequest.SetHeader("Accept","application/json")
  Do tHTTPRequest.SetHeader("Content-Type","application/json")
  Do tHTTPRequest.SetHeader("api-key",..ApiKey)
  do tHTTPRequest.EntityBody.Write()
  do tHTTPRequest.OutputHeaders()
  set tRequest = ##class(%DynamicObject).%New()
  set tRequest.searchString = pRequest.searchString
  set tPayload = tRequest.%ToJSON()

  set tURL=..Adapter.URL
  set tSC = tHTTPRequest.EntityBody.Write(tPayload)
  set tHTTPResponse = ##class(%Net.HttpResponse).%New()
  set tSC = ..Adapter.SendFormDataArray(.tHTTPResponse, "POST", tHTTPRequest, tURL, tPayload)
   If $$$ISERR(tSC)&&$IsObject(tHTTPResponse)&&$IsObject(tHTTPResponse.Data)&&tHTTPResponse.Data.Size {
         Set tSC=$$$ERROR($$$EnsErrGeneral,$$$StatusDisplayString(tSC)_":"_tHTTPResponse.Data.Read())
  }
  set tHttpResponseStatusCode = tHTTPResponse.StatusCode
  set tHttpResponseStatusLine = tHTTPResponse.StatusLine
  set tHttpResponseIsObject = $ISOBJECT(tHTTPResponse.Data)
  Set tHttpResponseContentLength = tHTTPResponse.ContentLength
  Set tHttpResponseContentInfo = tHTTPResponse.ContentInfo
  Set tHttpResponseContentType = tHTTPResponse.ContentType
  If ((tHttpResponseIsObject) && ($ZCONVERT(tHttpResponseContentType,"L") [ "application/json"))
  {
    set responseData = {}.%FromJSON(tHTTPResponse.Data)
    set pResponse = ##class(osuwmc.COM.Response.StringResponse).%New()
    if responseData.count =1{
      set pResponse.COMPortalURL = responseData.items.%Get(0).portalUrl
      set pResponse.COMPureID = responseData.items.%Get(0).pureId
      set iterator = responseData.items.%GetAt(0).identifiers.%GetIterator()
      while iterator.%GetNext(.key, .value) {
        if responseData.items.%GetAt(0).identifiers.%GetAt(iterator).typeDiscriminator = "ClassifiedId"
        {
          if responseData.items.%GetAt(0).identifiers.%GetAt(iterator).type.term."en_US" = "Scopus Author ID" {
            $$$LOGINFO(responseData.items.%GetAt(0).identifiers.%GetAt(iterator).value)
          }
        }
      }
    }
  }
  }
  catch ex {
    set tSC = ex.AsStatus()
  }
  quit tSC
}

But when I execute I am getting...

ERROR <Ens>ErrGeneral: Retrying Message body 9@osuwmc.COM.Request.SearchPerson / 3858480 because response 94@osuwmc.COM.Response.StringResponse / 121972 Status 'ERROR #5002: ObjectScript error: <METHOD DOES NOT EXIST>PostSearchPerson+37 ^osuwmc.COM.RESTOperation.1 *%GetAt,%Library.DynamicArray'

If I take out

      set iterator = responseData.items.%GetAt(0).identifiers.%GetIterator()
      while iterator.%GetNext(.key, .value) {
        if responseData.items.%GetAt(0).identifiers.%GetAt(iterator).typeDiscriminator = "ClassifiedId"
        {
          if responseData.items.%GetAt(0).identifiers.%GetAt(iterator).type.term."en_US" = "Scopus Author ID" {
            $$$LOGINFO(responseData.items.%GetAt(0).identifiers.%GetAt(iterator).value)
          }
        }

the code works fine...

I tried using Iterate over dynamic object | InterSystems Developer Community | Best

and got this...

Key: count
Type: number
Path: obj.count
Value: 1

Key: pageInformation
Type: object
Path: obj.pageInformation
Value:
Key: offset
Type: number
Path: obj.pageInformation.offset
Value: 0

Key: size
Type: number
Path: obj.pageInformation.size
Value: 10

Key: items
Type: array
Path: obj.items
Value:
Key: 0
Type: object
Path: obj.items.%GetAt(0)
Value:
Key: pureId
Type: number
Path: obj.items.%GetAt(0).pureId
Value: 1540250713

Key: uuid
Type: string
Path: obj.items.%GetAt(0).uuid
Value: 2a4f9baa-e937-4671-a55f-3f3bd17667d1

Key: createdBy
Type: string
Path: obj.items.%GetAt(0).createdBy
Value: root

Key: createdDate
Type: string
Path: obj.items.%GetAt(0).createdDate
Value: 2024-11-18T22:01:07.853Z

Key: modifiedBy
Type: string
Path: obj.items.%GetAt(0).modifiedBy
Value: root

Key: modifiedDate
Type: string
Path: obj.items.%GetAt(0).modifiedDate
Value: 2025-06-25T13:26:38.733Z

Key: portalUrl
Type: string
Path: obj.items.%GetAt(0).portalUrl
Value: https://xxxxxxxxxxxxxxxxxxx/en/persons/xxxxxxxxxxxxxxxxxxxx

Key: prettyUrlIdentifiers
Type: array
Path: obj.items.%GetAt(0).prettyUrlIdentifiers
Value:
Key: 0
Type: string
Path: obj.items.%GetAt(0).prettyUrlIdentifiers.%GetAt(0)
Value: xxxxxxxxxx

Key: version
Type: string
Path: obj.items.%GetAt(0).version
Value: 506af93393c24eeb70826afa0dd0ed473f1b61cc

Key: name
Type: object
Path: obj.items.%GetAt(0).name
Value:
Key: firstName
Type: string
Path: obj.items.%GetAt(0).name.firstName
Value: xxxxxxxx

Key: lastName
Type: string
Path: obj.items.%GetAt(0).name.lastName
Value: xxxxxxxxxxxx

Key: staffOrganizationAssociations
Type: array
Path: obj.items.%GetAt(0).staffOrganizationAssociations
Value:
Key: 0
Type: object
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0)
Value:
Key: typeDiscriminator
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).typeDiscriminator
Value: StaffOrganizationAssociation

Key: pureId
Type: number
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).pureId
Value: xxxxxxxxxxxxx

Key: employmentType
Type: object
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).employmentType
Value:
Key: uri
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).employmentType.uri
Value: /dk/atira/pure/person/employmenttypes/academic

Key: term
Type: object
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).employmentType.term
Value:
Key: en_US
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).employmentType.term."en_US"
Value: Academic

Key: organization
Type: object
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).organization
Value:
Key: systemName
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).organization.systemName
Value: Organization

Key: uuid
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).organization.uuid
Value: xxxxxxxxxxxx

Key: period
Type: object
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).period
Value:
Key: startDate
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).period.startDate
Value: xxxx-xx-xx

Key: primaryAssociation
Type: boolean
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).primaryAssociation
Value: 0

Key: contractType
Type: object
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).contractType
Value:
Key: uri
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).contractType.uri
Value: /dk/atira/pure/person/personcontracttype/openended

Key: term
Type: object
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).contractType.term
Value:
Key: en_US
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).contractType.term."en_US"
Value: Open ended

Key: staffType
Type: object
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).staffType
Value:
Key: uri
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).staffType.uri
Value: /dk/atira/pure/person/personstafftype/academic

Key: term
Type: object
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).staffType.term
Value:
Key: en_US
Type: string
Path: obj.items.%GetAt(0).staffOrganizationAssociations.%GetAt(0).staffType.term."en_US"
Value: Academic

Key: selectedForProfileRefinementService
Type: boolean
Path: obj.items.%GetAt(0).selectedForProfileRefinementService
Value: 1

Key: gender
Type: object
Path: obj.items.%GetAt(0).gender
Value:
Key: uri
Type: string
Path: obj.items.%GetAt(0).gender.uri
Value: /dk/atira/pure/person/gender/unknown

Key: term
Type: object
Path: obj.items.%GetAt(0).gender.term
Value:
Key: en_US
Type: string
Path: obj.items.%GetAt(0).gender.term."en_US"
Value: Unknown

Key: titles
Type: array
Path: obj.items.%GetAt(0).titles
Value:
Key: 0
Type: object
Path: obj.items.%GetAt(0).titles.%GetAt(0)
Value:
Key: pureId
Type: number
Path: obj.items.%GetAt(0).titles.%GetAt(0).pureId
Value: xxxxxxx

Key: value
Type: object
Path: obj.items.%GetAt(0).titles.%GetAt(0).value
Value:
Key: en_US
Type: string
Path: obj.items.%GetAt(0).titles.%GetAt(0).value."en_US"
Value: Assistant Professor

Key: type
Type: object
Path: obj.items.%GetAt(0).titles.%GetAt(0).type
Value:
Key: uri
Type: string
Path: obj.items.%GetAt(0).titles.%GetAt(0).type.uri
Value: /dk/atira/pure/person/titles/designation

Key: term
Type: object
Path: obj.items.%GetAt(0).titles.%GetAt(0).type.term
Value:
Key: en_US
Type: string
Path: obj.items.%GetAt(0).titles.%GetAt(0).type.term."en_US"
Value: Designation

Key: visibility
Type: object
Path: obj.items.%GetAt(0).visibility
Value:
Key: key
Type: string
Path: obj.items.%GetAt(0).visibility.key
Value: FREE

Key: description
Type: object
Path: obj.items.%GetAt(0).visibility.description
Value:
Key: en_US
Type: string
Path: obj.items.%GetAt(0).visibility.description."en_US"
Value: Public - No restriction

Key: identifiers
Type: array
Path: obj.items.%GetAt(0).identifiers
Value:
Key: 0
Type: object
Path: obj.items.%GetAt(0).identifiers.%GetAt(0)
Value:
Key: typeDiscriminator
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(0).typeDiscriminator
Value: PrimaryId

Key: idSource
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(0).idSource
Value: synchronisedPerson

Key: value
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(0).value
Value: xxxxxx

Key: 1
Type: object
Path: obj.items.%GetAt(0).identifiers.%GetAt(1)
Value:
Key: typeDiscriminator
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(1).typeDiscriminator
Value: ClassifiedId

Key: pureId
Type: number
Path: obj.items.%GetAt(0).identifiers.%GetAt(1).pureId
Value: xxxxxx

Key: id
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(1).id
Value: xxxxxx

Key: type
Type: object
Path: obj.items.%GetAt(0).identifiers.%GetAt(1).type
Value:
Key: uri
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(1).type.uri
Value: /dk/atira/pure/person/personsources/employee

Key: term
Type: object
Path: obj.items.%GetAt(0).identifiers.%GetAt(1).type.term
Value:
Key: en_US
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(1).type.term."en_US"
Value: Employee ID

Key: 2
Type: object
Path: obj.items.%GetAt(0).identifiers.%GetAt(2)
Value:
Key: typeDiscriminator
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(2).typeDiscriminator
Value: ClassifiedId

Key: pureId
Type: number
Path: obj.items.%GetAt(0).identifiers.%GetAt(2).pureId
Value: xxxxxxx

Key: id
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(2).id
Value: xxxxxxx

Key: type
Type: object
Path: obj.items.%GetAt(0).identifiers.%GetAt(2).type
Value:
Key: uri
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(2).type.uri
Value: /dk/atira/pure/person/personsources/scopusauthor

Key: term
Type: object
Path: obj.items.%GetAt(0).identifiers.%GetAt(2).type.term
Value:
Key: en_US
Type: string
Path: obj.items.%GetAt(0).identifiers.%GetAt(2).type.term."en_US"
Value: Scopus Author ID

Key: customDefinedFields
Type: object
Path: obj.items.%GetAt(0).customDefinedFields
Value:

Key: systemName
Type: string
Path: obj.items.%GetAt(0).systemName
Value: Person

Can I get a second pair of eyes to take a look and see what I might be doing wrong? or give me a hint on how I could extract Scopus Author ID from identifiers.ClassifiedID?

1 nuevo comentario

Comentarios (1)2

Inicie sesión o regístrese para continuar

Question 2

Pregunta

Life Bulb · 1 jul, 2025

#Reglas empresariales #Health Connect

Borderline character disorder (BPD) is a intellectual fitness situation that impacts a person’s emotions, relationships, and self-photo. People with BPD often experience severe temper swings, fear of abandonment, and problem controlling their feelings. Know-how the symptoms of BPD can assist the ones affected get the right assist and treatment. In this article, we are able to observe the key signs of borderline personality disorder, why it’s important to apprehend them early, and how to help a person residing with this condition.

Fear of Abandonment

One of the maximum substantive signs of BPD is a sturdy fear of being abandoned. Humans with BPD regularly worry that their loved ones will depart them or reject them. This fear may be so intense that they may visit terrific lengths to avoid being deserted, even if there’s no real cause to consider it's going to show up. Occasionally, they'll act out or emerge as overly dependent on others to save you this fear from turning into a truth.

Instance: a person with BPD might experience panicked whilst a partner doesn’t reply to a textual content proper away, questioning they’re being ignored or abandoned, even though this can now not be authentic.

Risky and extreme Relationships

Humans with BPD often have volatile relationships. They'll swing between idealizing a person (questioning they’re best) and then all of sudden seeing them as awful or untrustworthy. This shift can manifest speedy and is commonly based totally on how the individual feels in the interim. Due to this, their relationships may be intense, and the man or woman may additionally have trouble maintaining long-time period friendships or romantic partnerships.

Instance: a person with BPD can also grow to be extremely close to someone, believing they may be their nice buddy, handiest to all of sudden sense hurt or betrayed after a small confrontation.

Continual feelings of emptiness

Many people with BPD feel empty inner. This will be a persistent feeling, like some thing is lacking or that they don’t have a clear feel of who they honestly are. This vacancy can lead to frustration and confusion, and the character might attempt to fill it with unhealthy behaviors like immoderate ingesting, consuming, or speeding into new relationships.

Example: someone with BPD would possibly frequently alternate careers, pastimes, or even buddies in an try to feel fulfilled, however not anything ever appears to paintings.

Impulsive and volatile behavior

Impulsivity is a key feature of BPD. People with the sickness may additionally interact in volatile behaviors with out deliberating the outcomes. Those behaviors would possibly consist of spending money they don’t have, unsafe intercourse, or substance abuse. Regularly, these actions are pushed by emotional ache or the worry of being deserted. The person may additionally act hastily in an attempt to cope with their feelings in the moment.

Example: a person with BPD would possibly stop a task they’ve held for years on a whim, or suddenly start a new courting with out considering the lengthy-term effect.

Severe mood Swings

People with BPD frequently experience speedy and extreme mood swings. Their feelings can exchange quick, on occasion in response to small activities or stressors. One second, they might experience happy and upbeat, and the next, they could feel deeply unhappy, angry, or annoyed. Those shifts in mood can make it hard for the individual to hold stability in their daily existence.

Instance: After a minor confrontation with a pal or partner, a person with BPD would possibly experience surprisingly unhappy or irritated for hours, handiest to feel nice once more tomorrow.

Beside the point or extreme Anger

Another not unusual sign of BPD is trouble controlling anger. Humans with BPD may additionally have extreme reactions to minor issues, frequently feeling enraged or pissed off over small matters. This anger can cause verbal outbursts or maybe bodily aggression. Handling this anger is hard for someone with BPD, specifically once they feel misunderstood or rejected.

Instance: someone with BPD may lash out at a chum or member of the family over a small mistake, feeling like they’ve been harm or deserted, despite the fact that the situation isn't always that extreme.

Self-harm and Suicidal thoughts

Self-harm, which include slicing or burning, and suicidal thoughts are alas not unusual in people with BPD. Those behaviors are usually a way to address overwhelming feelings or feelings of emptiness. For a few, self-damage is a way to “experience something” or to distract from emotional pain. If a person you realize is self-harming or speaking about suicide, it's far very essential to take it significantly and encourage them to are searching for expert assist.

Example: someone with BPD may additionally harm themselves once they experience overwhelmed by means of their feelings, or they might speak about suicide as a manner to deal with their internal ache.

Risky Self-image

Humans with BPD often warfare with their feel of self. They'll sense unsure about who they're or what they need in life. This lack of a clean self-image can result in common adjustments in how they look, what they trust, and what they want to do in the destiny. The individual may have feelings of worthlessness or self-loathing, which can make it tougher for them to locate peace with themselves.

Example: a person with BPD may additionally abruptly alternate their appearance, style, or profession route, most effective to experience uncertain approximately these changes quickly in a while.

Why spotting BPD symptoms Early Is critical

The sooner Borderline character ailment is identified, the sooner a person can get the help they want. Remedy for BPD generally consists of therapy, which includes Dialectical conduct remedy (DBT), which focuses on helping humans control their emotions and improve their relationships. In a few instances, remedy may also be prescribed to control symptoms like melancholy or anxiety. Getting early treatment can assist lessen the severity of the disorder and enhance the man or woman’s excellent of life.

How to support a person with BPD

Assisting a person with BPD can be tough, however it’s essential to expose care and staying power. Here are a few tips on the way to provide guide:

Pay attention and display empathy: human beings with BPD frequently feel misunderstood. Paying attention to them with out judgment and showing empathy can help them sense heard.
Set healthy limitations: even as it’s vital to be supportive, setting boundaries is also important. This enables defend your emotional health and encourages the individual with BPD to take duty for his or her conduct.
Encourage expert help: in case you suspect that a person you already know has BPD, inspire them to are searching for expert help from a therapist or counselor. Remedy could make a huge difference in dealing with symptoms.

End

Spotting the key signs and symptoms of Borderline persona disease is step one toward supporting someone control the circumstance. Even as BPD can be hard to apprehend, it is treatable with the proper remedy and support. In case you or a person you recognize is displaying signs of BPD, it’s vital to are looking for professional assist. With the proper equipment and treatment, people with BPD can lead pleasing lives and build wholesome, lasting relationships.

By spotting the signs and offering knowledge and guide, we are able to help those with BPD find the assist they want and work toward emotional stability and recuperation.

Comentarios (0)1

Inicie sesión o regístrese para continuar

Question 3

Pregunta

Shashvati Dash · 1 jul, 2025

#JSON #ObjectScript #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS

The below code is not working. its unable retrieve Record count and merge files

Class Util

{

ClassMethod zPyRecordCount(inputfile) As %Integer [ Language = python ]

{

import pandas as pd

import iris

import io

try:

df = pd.read_csv(inputfile, sep='|')

recordcount=len(df.index)

sys.stdout.write(len(df.index))

return recordcount

except Exception as e:

return 0

}

ClassMethod zPymergefiles(file1, file2, outputfilename) As %Boolean [ Language = python ]

{

import pandas as pd

import iris

import io

try:

dataframe1=pd.read_csv(file1, sep='|')

dataframe2=pd.read_csv(file2, sep='|')

jsondf1 = dataframe1.to_json(orient='records', indent=0)

jsondf2 = dataframe2.to_json(orient='records', indent=0)

mergedjsondf=pd.concat([jsondf1, jsondf2], ignore_index=True)

with open(outfilename, 'w', encoding='utf-8') as f:

json.dump(data, f, indent=0, ensure_ascii=False)

return 1

except Exception as e:

return 0

}

Set mergeStatus=##class(Util).zPymergefiles(inputfile1,inputfile2, "outfile1.json")

1 nuevo comentario

Comentarios (2)3

Inicie sesión o regístrese para continuar

Encontrar

InterSystems Developer Community Digest, June 2025

Iteration Help through JSON Response

Recognizing Key Signs of Borderline Personality Disorder

Fear of Abandonment

Risky and extreme Relationships

Continual feelings of emptiness

Impulsive and volatile behavior

Severe mood Swings

Beside the point or extreme Anger

Self-harm and Suicidal thoughts

Risky Self-image

Why spotting BPD symptoms Early Is critical

How to support a person with BPD

End

Building from the Edge In: What Pool Tiles and Coping Can Teach Us About System Design

What Are Pool Tiles and Coping?

Our Repair Process

Why Pool Repair Is Essential in Cape Cod

Common Pool Issues We Repair

Need to merge 2 pipe delimited files after converting it into json